2 dbs to 1 using a form

[Guest]

I would like to pull automatically from 2 or more other dbs based on a
selection in a single field in the target db pre populating many of the
fields but not all. I would like to do this using a form that based on the
entered or selected content forces multiple other finds to populate leaving
only the fields remaining that lack the data.

The target db will be a permanent history and will not change after a record
is created regardless of the changes made in the source dbs.

 

[Guest]

All of this is possible but you need to ask specific questions because we
can't design the entire database for you. Are you confusing databases with
tables? A form is normally based on one or more tables not one or more
databases.
The first thing you need to do is to design your tables and relationships.
Preferably each form should be based on one table and that is as much a
function of how you design your tables as how you design your forms.

-Dorian