Duplicate record and child records
 

I have a Access 2003 database which has a table we'll call orders.
There are 10 other tables linked to orders through Order_ID.

I'd like to be able to create a duplicate of a record and all the associated records in the linked tables.

I've read it possible with an append query, but I'm wondering if there is a way to filter a recordset and then append the recordset back to the original table. 11 recordsets, 11 filters and 11 appends as opposed to 1 huge dirty query which would be harder to debug in my opinion but i'm more than open to advice and options here.