I’ve managed to develop a way of copying a row from a Parent table along with its Child records.
It uses a number of actions and a workflow, triggered when a new parent record is created.
It takes a few seconds to update the children as the app syncs, but the main functionality is there.
I’m going to be using it to copy the parent and child records so that it’s possible to create a historic record of reports that can be secured as un-editable for record keeping. By creating a new copy of the parent record, new details can be added and a new record created.
There will hopefully be umpteen other uses.
You can see a copy of the app here
Parent and child App