>Lincoln,
>
>In regards to your first question, this is a known bug in the View Designer. If you need to construct views made up of more than 2 tables do it progromatically using CREATE VIEW AS SQL .........
>
Just to add to that bug description :), that you actually can create views with more than one table if they are joined in chain, but not with parallel joins. And after you created such a view programmatically, don't try to open it in View Designer, it will be screwed up again.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison