>The View designer for VFP7 and earlier is brain dead when it comes to complex views, so it can't create the view you are wanting.

I was afraid of that....

>
>What Esparta was telling you though is that you can use a CREATE SQL VIEW command to write your complex view into the DBC and then it'll be available for use.
>

Sounds good....

>You can open the view designer to grab the code from your existing view and then move that to a PRG that you will use to edit the view definition from now on.
>

Ok...

Thanks!
Tommy