By "1toN" you mean "1 to many"?
Of course you are not using these for primary keys. What do you need to do with the data afterwards?
Here's a file with 2 ideas, a merge field and a calculation. I don't think you need a script unless you need to do further calculations
Hi Steve Martino,
I indeed mean "1 to many".
In fact, I want to do the following :
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).
What I would like to do now is creating alternative scenarios with different financial outcomes. This means that for each project, I would like to have a script that creates a new record in table B (called "Simulation 1", etc) + 5 records again in table C.
For the ease of usage, it would be ok if the original "base scenario" and its 5 records in table C just get duplicated.
I tried several forms of scripts but the only thing I achieve is an endless loop that duplicates thousands of times my record in table B or one of the records in table C... :-s
Any idea what I could use here?
Thanks in advance for your input!
Just an update to explain how I manage to solve this.
I added a new record to my TableB called "code" and as my first record for TableB is created together with the creation of the record in TableA, I added to the creation script that the "code" for this record should be 0.
When I create a new record for TableB, my script checks for the max "code" and adds 1 to this number.