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.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |