Copy this row and edit current row and all relevant children

[RLCDProperties]

I’m creating a MoveIn/MoveOut Inspection app, and would like it to work like this:

1. Create a Move In Inspection record, with the inspections from each room/area residing in its own table and referencing to the Move In inspection being created.
2. Upon Move Out, copy the corresponding Move In, including all of the applicable children rows from the other tables, change the row key values to new unique values and then be able to edit that new Move Out record and its children.

I’ve seen various questions sort of like this previously but no good answers and am hoping something has changed or I’ve missed something. It’s easy to copy and edit a single row, but I can’t figure out how to do the same with its children.