Hi Michael,

I am working on something similar right now and have taken an approach similar to what Jim suggested. I have one dbc and the tables contain info for all projects with a defining key of Projnum. I then created parameratized views of the tables based on Projnum and use these views in the forms of the app. When the user starts the app they choose a project from a picklist and I use this value for the views. Like Jim suggested, this will allow me to compare project to project and easily switch from one project to another. HTH

>In my current application, I figure I need a seperate DBC for each project. I expect to prompt the user for the project (from a list of .mem files), read general project info from the mem files, open the DBC in a directory by the same name as the project, and run the appropriate forms.
>
>I already have the data environment for those forms currently set. Will I be able to just set the default directory before running the form and have it just open the correct dbc, or will I need to open tables and set relations in code - stripping away the data environment from the form?
>
>Advice would be appreciated....
>
>TIA