Open each table in a separate instance of the same Form. Only show the Form for the "active" table. When switching tables, show the "new" form in the same position (over the "old" form), and then hide the "old" Form.

(You may only want to instantiate a new Form as needed if resources are a problem, tho switching may take longer).

I used to do this to simulate multi-page Forms in FPW, and it worked quite well.

>Hi,
>
>I want to open 4 tables that are identical is structure, same name except for a numeric trailer (e.g. test1.dbf, test2.dbf, test3.dbf, test4.dbf). I would like to open them all at once at the beginning of the application, but refer to them from a form with a single alias name.
>
>For example, a form has it's controlsource for it's fields tied to the alias "test". When I open "test1", I will set it's alias to "test". When I navigate to the end of table "test1" on the form, I want to switch the alias name "test" to now refer to table "test2", and the form will begin displaying records from "test2".
>
>The reason for this is that the records in a particular table has reached the VFP limit and we needed to break the records apart into separate tables. Now I would like to make it act like a single table by switching from table to table dynamically and seamlessly, so the user doesn't know it is happening.
>
>Any ideas on how to accomplish this?
>
>Regards,
>
>John