I'm relatively new to VFP 5.0 - I'm developing an application where I'll be using multiple databases (all related tables in them will be identical in terms of structure). I want to use the same forms for all the databases, and simply be able to switch between them as needed. My question is: it seems that the data environment is best suited for a single database. Am I better off not using the data environment for my forms creation, and 'manually' opening the databases using SET RELATION commands? Or, is there something I'm missing in the data environment/form designer?

The general question: how does one best handle multiple databases using common forms? Is the data environment useful in this case or not?

Thanks for any suggestions....