Lincoln,

I wonder why you were advised that "the best way is through views"??? Is there something about your code which is intrinsically *NOT* multi-user???

Views are some people's opinion the *best* way to do most things. For others, views are used only sometimes. I guess there are even people who never use them. One thing is certain, and that is that you do not *NEED* to use views to have a successfuly multi-user system.

What are your concerns regarding multi-user? Maybe if you tell us those we can get you into a working system a little quicker.

Good luck,

Jim N


>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