Automate data entry of multiple records

D

dtwombly

I have a database for keeping track of equipment orders and sales;
since we generally order standard configurations of each equipment
model, I store these standard configurations in a table that relates
model numbers to option numbers (tblModOpt). This table connects two
separate tables that include information for each model and each option
(tblModels and tblOptions).

I have another table for each piece of equipment we actually order
(tblStock), and the piece of equipment's options are stored in a
related table (tblStockOpt). When I create a new order, I would like to
select the model and have its standard configuration of options (in
tblModOpt) populate tblStockOpt. I can make the DLookup function
retrieve data for a single record, but I don't know how to retrieve
multiple records. I'd be grateful for any help.

Thanks,
Dave
 
Top