Populate tables enmasse

  • Thread starter Thread starter Mattie
  • Start date Start date
M

Mattie

I have a primary main form/subform where the primary/foreign key is DivisionID.
I enter divisions in the main form and companies in each division in the
subform. There are thirteen other tables that have DivisionID as a foreign key.
I'm looking for recommendations on alternative ways to add DivisionID to the
other thirteen tables simultaneous but in the background when I am creating
records in the primary main form/subform. All the other tables are part of a
form/subform system with the divisions table and I want to be able to open any
of these form/subform systems immediately after entering a division in the
primary form/subform and have blank records to fill in.

Thank you for all assistance!

Mattie
 
Why would you want to load entries into the other tables unless you have
data associated with those entries?
 
I do have data! I want to prelaod the other tables and then I can use a form
designed like a list and quickly enter my data with out constantly having to
enter a new DivisionID. The traditional way would be to enter the DivisionID in
the main form, enter the data in the subform and then repeat for the next
DivisionID. And I'd have to do this for all thirteen other tables.

Mattie
 
Back
Top