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