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.
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.
Interesting idea! Are you thinking only direct children or all recursive children?
I was thinking of one level, but I could see a use for all recursive children.