Insert 100 records

[dogman01]

First let me start by saying--<So far the support I have been given on this forum has been great. Started new job 3 wks ago and have to database labratory results from testings of milk samples.>-- To my question. I have a main form from the main table that acts as a login for main test samples. Within that form is a subform from a "Results" table that houses 100 individual testing results associated with that main record. Only issue is a user has to manually insert those 100 records each time. Is there an easier way so that when a main log in record is created, 100 blank sample result records could be inserted to the results table and the lab technicians can then just simply fill in each result record with data. Hope this isn't to much to ask for help on.

 

[Datagopher]

I'm not understanding you're reason for wanting to do this. It sounds as though you have it setup correctly with a main and sub-form. Are you wanting to do this because some of the fields will be identical for each of the 100 records? That's the only reason that I could think of as to why you might need something like that.

 

[dogman01]

Yes, with each main log record there should be 100 sample results records associated with it. Just trying to find a time saver for the user so they won't have to manually insert 100 records each time. Thanks

 

[wiremonkey22]

Not sure i understand but maybe create a table called sample with all the sample records that will never change and have a query that appends or updates to your main table????