Hope you can help me with this issue.
I have a parent table “Orders” and a child table “Order Details”
Both have a “status” column… the child status column must be updated based on the parent status column.
Status column is not a virtual column
Child “status” column formula is: lookup([_thisrow].[cod_order],“orders”, “cod_order”, “status”)
The issue is that, I have to enter to each child row and click “save” to actually commit the update.
How can I automatically update the child column after I update the parent one.
Hope you can help me out with this.
Thanks and regards