Hello.

I want to modify one app, in the following way:

The customer is an firm wich want to work for different companies in the same time. Because the data are huge and almost all the reports and queries are limited to one month, I want to split the database in the following way: (this is the directory structure)

FIRM1
January
February
March, etc
FIRM2
January
February
March, etc
FIRM3, etc, in the same way.

I want to do this mainly because the firms have different needs and one firm's database doesn't look like another firm's database.

The main problem I have is the form's dataenvironment. I cannot add any table or view to the dataenvironment, because the form will open automatically the same database. I can manage to find a way to add them programatically, but it seems to be very complicated.

Can anyone help me? I am looking for a short way to add the tables and views to DataEnvironment, assuming I know the database they are contained in, and the name of the view or table.

Or, maybe, there is a 'DataEnvironment Builder'? In the ideal case, I think it has to be a control placed on the form, and the control have to read from a separate table the views and tables names for the loading form and then add them to the form's dataenvironment. At the unload event, it have to close them. Have anyone done such thing?

Thank you,