>>>>In previous version of Visual FoxPro the view designer could not handle multiple joins to the same table is this still a problem in v7.0
>>>
>>>Yes it is! I think MS Team should really fix this or just buy e-view from E. Moore and integrate it in VFP and release it during SPs. Voodoo and WC are also great additional stuffs. :)
>>
>>Jess, I was able to do a self join without problems in 7.0. Can you send me your SQL so that I can duplicate it?
>
>The problem isn't with self-joins, but with what I call multiple unrelated children. That's where you have a single parent, but several child tables, with no relationship among the child tables. For example, using TasTrade, imagine a query of Orders where you want to get the Shipper, the Supplier and the Customer. The QD/VD can't handle that.
>
>Tamar

Thanks for clearing that up.