duplicateFoundSet or copying a record and its related record

[IT2Be]

What would be the best way to copy a record and all it's related records into a new set. Something like copying a company including it's addresses or whatever variant...

Can duplicateFoundSet() help me here? And if yes how?

[jcompagner]

what doe you mean into a new set?
do you really want to duplicate everything in the database?

so a company "it2be" with a pk of 100 should be duplicated and given a pk of 200?
and when you do that it should also duplicate all the related things??
(that is a bit harder. your could go through through youre relations yourself and duplicate somehow every related record and set then the fk to the pk of the new parent record.....

[IT2Be]

Yes, that's exactly what I was thinking of. I hoped it would be a little easier but ok...