I have a product table, an order table and an order detail table.
When an order has been delivered the user manually “archives” the order.
The order may have more than one product in it and so more than one quantity to remove from more than one product inventory.
I have an action button to set the [Order Status] of the order to “Archived”. I intend to set up another action to subract the correct quantity from correct porduct.
Execute and action on a set of rows:
For a record of table : Orders
Referenced Table: Products
Referenced Rows: This is where I need the expression to give the row in the Products table that matches the [Unique Product Id] in the Order Details table in relation to the Order Id this row selected