Hi Dave,

You can still create this same SQL in a view using the view designer without any problems. In the Filter Page of the view designer setup your where condition and it will work.


>Hi John,
>I finally gave up on the View Designer and just made the RowSourceType - 3-SQL
>
>and put the following in the RowSource:
>
>select st_status,st_id from status where st_id in (select notes.st_id from notes) into cursor Ct_stats
>
>
>Thanks