Duplicate records from several tables?
I have a "project" (record in table A) and for this project, I have created a "base scenario" (record in table B) which includes financial info (per record in table B, there are 5 records in table C).
I have therefore created a layout linked to table A and I have 2 portals on this layout in order to show both the "scenario info" (record in table B) as the "financial info" (records in table C).
What I would like to do now is for the shown record in table A, duplicate both the record in table B and the 5 records in table C. The new record in B should still be linked to the original record of table A and the 5 new records in table C should be linked to the new record in table B.
I have tried several variations of scripts that I have found on this forum but for the moment, none gave correct results. Or I have my script that does not execute, or it loops and creates thousands of records until I stop the script manually... :-p
Do you know how I could solve this?
Thanks in advance for your input!