Update child ref column from parent

Hi everybody!

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

1 Like

Thank you for this one!

Problem solved!

2 Likes