Sounds like VFP 8.0's View Designer will be a winner.....

Tommy

>>>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....
>
>If you've got the VFP8 public beta, its View Designer is *much* better. I downloaded the beta myself for that reason alone. VFP 7 will use the views with no questions asked, but you can't edit them in 7.
>
>Chris.