a2k - best way to make a copy of records to the same table?

[Deano]

I have a feature where the user is allowed to make a copy of their data.
Some of these tables are related to a child table.

From what I can see the easiest way to do this is to copy to a temp table
then append back and fiddle with the related fields.

Does this sound alright?

thanks