>>Are VFP views limited to two tables? When I try to put 3 joined tables in my view one of the joins doesn't work properly (it's displaying the wrong data) and when I trly to save it I get the error, "SQL column blah not found."
>>
>>Yet another VFP feature?
>
>Actually it is a bug. :) There is an error in View Designer when you try to create one-to-many joins visually. You are still able to create them programmatically, but do not open them in the View Designer then.
>
>Nick
Michael, check also Articles Q157254 and Q156667 in Microsoft KB.
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