Hiya Dave

Not a bad idea either....what works, works. Still, you might want to get familiar with creating views in source code. The View Designer is really inadequate for complex JOINs and UNIONs.


>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