that worked a dream thanks, brain refuses to function at this stage.
Slán
~M

>To get all records of table1 where field1 has is in contained in cursor1.field2:
>
>

>select * from table1 ;
>   where field1 in (select field2 from cursor1) ;
>   into cursor cursor2
>

>
>>hi all,
>>i am having a bit of trouble remembering how to do this code. i have table 1 and cursor1 but i cannot get the 3rd line correct, have written it as i mean it to work.
>>
>>selcet * ;
>> from table1 ;
>> where table1.field1 is in cursor1.field2
>> into cursor2 nofilter
>>
>>any help much appreciated.
>>Slán
>>~M