AnsweredAssumed Answered

Duplicate records from several tables?

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

Title

Duplicate records from several tables?

Post

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,

_Fred_

Outcomes