>VFP View designer cannot handle views which contain more than 2 tables. When you attempt to create a view with 3 or more tables, after it crashes it should pull up a SQL screen. The code should all be there - just copy it into the command window (you may need to rearrange it in Notepad or something first) if you just want to run a query. If you need to save the view, get eViews.
>
>Hope this helps
>
>-Justin
Not true. I can easily specify three or more tables in a view. Try this:
OPEN DATABASE TasTrade
MODI DATA
Right-click and add a new local view
Add Customers, Orders, Order_Line_Items
Select all fields to be in the view
Press Ctrl+W
Name the view, click OK
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer