Can I create/duplicate 10 new records in table B and assign these the ID of a row from table A?

[biota]

I have been trying to do this with a simple trigger but it looks not to be possible due to lack of a common value/field.

The first part of the trigger works fine: 

- On insert to table A, insert/duplicate 10 rows from a lookup into table B.

However I need those rows to have the ID of the row in table A which triggers this.

The problem I suppose is there is no relationship with or PK in the lookup table.

The first part could also be achieved by having 10 'dummy' rows in table B, which the trigger then duplicates. This removes the need for a lookup table and reduces the trigger to linking two tables rather than three. It just seems slightly messier in that any additional rows could mess things up.

But if it works I could live with the latter.

It looks at the moment like it might have to be handled by receiving a parameter in the datapage for all this, but that could be very messy also.

Any suggestions welcome!

TIA

 

 

[ParkLoey]

Hi @biota have you tried using variables to store the ID value of the inserted row? You can then use the variable for setting values without the use of common fields.

I hope this helps!

[biota]

I will give that a go @ParkLoey, thanks! 

[Queso]

Hi @biota,

Just to add more information regarding ParkLoey's suggestion, you may check this article for more information about Variables in Triggered Action/Tasks: https://www.caspio.com/blog/automate-workflows/#:~:text=3.-,Variables,-Caspio also makes