>I am trying to develop a system which could be used for many customers. My problem is I want to develop forms,queries,views etc for generic purpose. For example, When I develop CUSTOMER form, I want to use it for customer table in databse container of customer1 and use the same form for customer table in databse container of customer2. I guess, my question is how do I specify data source in form design which will have the same table name but in different database containers for different customer depending on selection of customer account.

I do a lot of this, due to the way our data is cycled, I have dozens of DBCs that are very similar and are constantly created and archived. I don't use the project for the DBCs, nor the DEs for tables, that cuts out a lot of problems. Opening things manually is easy enough with a few properties to hold path/DBC names, and just using the same alias on different DBC tables once they're open is simple enough for all the controlsources...