In "Actions", how do I set value to a REF column of a new row to maintain the table relationship?

In the screenshot, I need to add a new row in table “Invoice” which has a REF column to “Order” table. So I need to assign a value in the REF column “Order Id” of the Invoice table. How should I do it here? Thanks for advice.

Please try

A) In the left side window of the actions’ s set these columns : Order ID
Here “Order ID” is the ref column in “Invoice” table

B) In the right side window of the action’s set these columns : [_THISROW].[Order ID]
Here [Order ID] is the key column in the Orders table

Edit: there was a problem in description- table names were reversed. Corrected it.

1 Like