AnsweredAssumed Answered

Duplicate records from several tables?

Question asked by FredH on Nov 18, 2014
Latest reply on Nov 20, 2014 by FredH


Duplicate records from several tables?


Hi experts,

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!
Kind regards,