Tamar had a good point about joining unrelated tables. Look at her posting in this thread. Also, if you change the order of the joins, you can often get the view designer to work.
As for _VIEWDESIGNER, you could call any view designer you wanted from the GUI.
>Craig,
>
>I don't get this. What does a hook like _VIEWDESIGNER change? I can use what I want without a hook. The *real* issue is that there's no good view designer available. Sure I use eView and ViewEdit. I like these fine tools, but they certainly don't replace the view designer that should be part of VFP.
>
>I've mentioned this before, but I really like the view designer that ships with Enterprise Manager in SQL Server. It's the best view designer I have seen - even better than the one in Access.
>
>Change any parameter in any of the 3 panes and the others reflect the changes immediately. It's a perfect 3-way tool! Also, the designer creates sequential JOINs rather than nested.
>
>This is already an MS tool. How hard would it be to port this to VFP? The most difficult part in my opinion is the parsing and the 3-way synchronizing. This is already done.
>
>What really beats me is that I can think of 4 different query/view designers in MS products (SQL Server, Access, VFP, MS Query). Each one uses a completely different interface. If they took the best of each, we'd have a real good designer. Unfortunately for us, the designer in VFP is not only the worst one, but simply unusable when you have more than 2 tables :(
>
>Heck, even MS Query has 2-way support. That is, you can make changes to the SQL code and these changes are reflected graphically.
>
>
>>IMO, there are other designers as good or better than e-view. How about if the VFP team provides a hook, something like _VIEWDESIGNER. Then you can use what you want.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer