Lincoln,

First of all, I agree with Jim, using views is neither better or worse for dealing with multi-user. What you need to concern yourself with is TABLEUPDATE() and TABLEREVERT() and either use RLOCK/UNLOCK functionality or have code to handle when a TABLEUPDATE() fails (i.e. another user updated at the same time).

In regards to your first question, this is a known bug in the View Designer. If you need to construct views made up of more than 2 tables do it progromatically using CREATE VIEW AS SQL .........

HTH

>I'm using VFP5.0. I developed my database in single user mode with numerous tables, free tables, etc. I designed a multipage (pageframe w/8 pages) form which works reasonably well. I need to go to a multi-user environment and have been advised that the best way to do this is through views. I have tried creating several different views but nothing seems to work the way I want it to. I see two basic problems:
>1) I cannot create a view with more than three tables without generating an error message "SQL: Column 'Key_ID' is not found." even though the "Key_ID" field exists in all of the tables. I had hoped to include all the tables in a single view and then copy the form substituting the view names for the table names in the form.
>2) Since I can't create one view for all tables, I tried creating several views, each one combining two or sometimes three tables. My problem with this is that when I try to advance to the next record using a "cmdNext" command button (that worked perfectly in my original form built directly from the tables), it works correctly only on the first page, the other pages use different views to populate the form but I can't get them to advance to the next record; alternately, if I get page two to advance and then return to page one , page one is still on the original record and not the same one as page two. I suspect there is an easy solution to these problems but I remain at a loss to solve them. I would appreciate any assistance.
>TIA --lincoln