Copy and add new records based on Dlook up.

[Axel.Larcy]

Cross posted in AccessForums.net.
How do I copy and also add records based on the Old ID. I am creating a database for FMEA as my college project.
In the attached DB form I have used cascading combo boxes to filter information. I have a child record "oil seal" with ID 1 under the parent record "pump". Now I have added the same child "oil seal" now with new record with ID 10 under a new parent "Equipment X".
How do I get to copy and add a new record for the Failures and Causes of the "oil seal" with ID 1 to the "oil seal"of ID 10?

 

[pbaldy]

Can't look at the sample right now, but is this appropriate?

http://allenbrowne.com/ser-57.html

 

[mike60smart]

Hi

You would normally do your Data entry for this type of setup with a Main Form to enter the Equipment with as Subform to enter the Part and then another Subform to enter the Failure Reason and Cause

View attachment SampleDB.zip