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