>I tried this yesterday but I wasn't getting my question across clearly.
>
>The application issues the following:
>SELECT 1,2,3 FROM MyTable WHERE 1 = "Blue" INTO CURSOR MyCursor
>The contents of MyCursor can be practicaly anything, but field1 is a primary field.
>
>
>Now I want to do (at design time):
>SELECT 4,5,6 FROM MyTable WHERE 1 = only those records whose field1's match those in MyCursor.
>
>Can this be done?
select 4,5,6 from Mytable2 where MyTable2.IDField in (select field1 from Mytable1) ...
Mark McCasland
Midlothian, TX USA