I&#039;ve used data shaping to query my database and it works find, but i want to impose restrictions on my query - can this be done?<BR><BR>SQLGenBet = "SHAPE {SELECT SubCatgID From staSubCatg}" & _ <BR>"APPEND((SHAPE {Select EventClassID, EventClass From staEventClass} AS Class" & _ <BR> "APPEND(Select EventTypeID, Name, Note From prcEventType} AS Type" & _ <BR> "RELATE EventClassID TO EventClassID))" & _ <BR>"RELATE SubCatgID TO SubCatgID)" <BR><BR>I want to SELECT SubCatgID From staSubCatg where SubCatgID = 56 <BR>but it doesn&#039;t seem to work!