>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
Michael,

I woudl suggest that you dump the mem files and store all information for all projects in one database and its tables. Create an index on projectID for every table that has that field and you can use SELECTs or filters to show only the project you want in the forms.

This will allow you to provide reports that cover all projects or that compare one project to another etc. Things the users are bound to ask for sometime.