Creating several new records in a table based on a number entered in a form

[rajsa]

Hello,



I am building a database to log laboratory samples. I have two tables: tblSample and tblReplicates:

tblSample
ID
Strain
Protocol
Project
Date
No_Replicates

tblReplicates
ID
SampleID (from tblSample:ID)
Location

Ideally the user would enter the number of replicates in tblSample, and this would automatically create x number of records in tblReplicates so the user would just need to enter a location for each, say on a subform. The number of replicates will vary.

Any help greatly appreciated )

[orange]

Do you have an authoritative list of Locations? This could be in a combo on the data entry form.

[rajsa]

Do you have an authoritative list of Locations? This could be in a combo on the data entry form.

I do, but that still doesn't solve my problem of needing to create x number of records (one for each replicate), ideally without the user having to create these manually.