I am trying to create a local view - when I add a fourth table to it (with the appropriate inner join), I get a "column not found error".

The column IS there (honest), what's more, if I run the view, I get the correct output, but the error occurs when I try to view the SQL or save the view. The column referred to changes depending upon the order of the tables.

If I select the SQL and execute it (or create the view using the copied SQL) all is well until I try to modify the resulting view and...bang...no column.

Am I running into a limitation of VFP - i.e. the view designer cannot handle 3+ tables?


RJL