copy a record and subrecords

[JumpinJimRivers]

How do you do this? Obviously the new subrecords need to have the new main records ID as its foregn key and not the old main record, so how is this done?

 

[scking]

You've left your question open to about a 1000 interpretations. Using VBA this would just be a matter of a lot of easy code.

From a form:

-Read the current values
-Open a recordset and use the AddNew method to create a new main record.
-Assign the value of the new main ID to a variable.
-Read the value of each related records.
-Open a recordset and use the AddNew method to create a new related record and use the value for the main ID as the foreign key.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[JumpinJimRivers]

Sorry for the vaguery- I was trying to keep it general since too much info sometimes confuses things. Thanks for the input. I'll give it a whirl with your outline.