Help with Action to Add an Item to my child records

[Quality_Assuran]

Hi community

I need some help with an expression.

I want to run an action from my parent table to my child table. The action I want to do is to add a new row to another table using values from this row.

I've set up the action above on the child table, then setup an action on the parent to execute an action on a set of rows referencing the above action.

The referenced rows I used was [Related Children] but if I have more than one child record it produces a new row in the child table for each of the existing records when I run an action. 

What could I use in the Referenced Rows section to only produce one new row in the Child Table when running the action from the parent table?

[TeeSee1 · Accepted solution]

If it is OK to use any one of the [Related Children] rows to base your new child row on, then you should be able to use TOP([Related Children],1) as your expression.

[Quality_Assuran]

Thank you!