>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

Yes, it's limitation. You can workaround either by creating a view programmatically CREATE SQL VIEW ... , or by limiting number of joins in view and extending output interface functionality.