Roi,
As Mark said, you could build an IN clause if the number of possible values are limited. Instead of a sub-query, you could achieve the same result with an INNER JOIN.
>Is is possible to use a cursor as the IN clause of the where clause of a select statement?
>
>I have the following now:
>
Create Cursor Tasks (taskID I)
>Append From Array thisform.snptaskrange1.selecteditems
>
>** now build the real cursor
>Select * ;
> from rsAllWos ;
> where fk_task_id in (select * from tasks) ;
> into Cursor rsWoTaskSubset
>
>
>Is there some way to do:
>
where fk_task_id in (tasks)
Daniel