You can do it in two steps
SELECT * FROM ParentTable ;
WHERE &lcFilter ;
INTO CURSOR crsParent
SELECT ...
>If I have a parent/child relationship established and the parent table is filtered via set filter to . . . .
>
>I want to use SQL SELECT to create a cursor from both tables containing only the records that are consistant with the filter established in the parent table, the following code seems to work . . .
>
>lcFilter = filter()
>
>SELECT FROM etc etc
>WHERE &lcFilter ;
>etc etc
>
>There are however 2 problems. The first of these is that if the filter condition references a field that is contained in both tables, such as the join field, it will crash. Prefacing the field with the alias when the original filter is created corrects this but getting my user to do this will be difficult.
<snip>
--sb--