>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
Tommy Tillman A+ NetWork+ MCP