i have a couple of tables with a "one-to-many" relationship.

i want enable my users to essentially "duplicate" the data from a parent
record into a new record, but also duplicate "child" records associated with
that parent, linking the duplicated child records to the newly duplicated
"parent" record.

ideally, i would like to do this as the result of a command button "on
click" event.

however, i really have run out of ideas! can somebody help???

thanks in advance! Steve