Duplicate rows from multiple tables and keep relationships

1

I have tables with a Parent/Child relationship.

I’d like to duplicate the Parent row and any associated Child rows and keep the new rows linked to each other.

Basically, this is so I can have a “template” of rows.

2

Interesting idea! Are you thinking only direct children or all recursive children?

3

I was thinking of one level, but I could see a use for all recursive children.