Using form/subform for multiple records

[silentsiren76]

I would like to create multiple records with one form where data in several fields is copied to each record. The fields that need to be copied are in the form where the fields for each unique record are in a subform. There may be a better way to set this up but this is all I've come up with so far.

I need the form to create multiple records with the same date, machine #, product name, lot #. Once that information is entered, I can enter in multiple reject types and amounts for that product. I need each reject type and amount in a different record for that lot/product and then I choose when to change the date, machine, product, and lot fields.

Right now, I can enter the information that I need copied to each record but it doesn't carry forward to the records where I enter the information on the sub-form.



I hope all that is clear. Any help would be greatly appreciated!

Amy

[rzw0wr]

Take a look at your tables first.
Machine,Products and Reject Reasons should have a PK type as autonumber.
Use the new PK as a relationship to the FK of the othe tables.

Example, tblMachine
tblMachine_ID Autonumber PK
Machine Text

Same with products. Change Reject Reasons to one word. No spaces in object names.

In tblMachine you will have relationships to all the other tables 1 to many.
The other tables will have a FK to tblMachine PK.

let us know if we can help further.


DB project.zip

Dale