Update child ref column from parent

[SARO_Pruebas]

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

[Marc_Dillon]

Quick Update System - How to update records in your app with a push of a button Tips & Tricks 💡

“How can I update a parent record when a child record is changed?” “How can I mark all the line items in an invoice as paid when I mark the invoice as paid?” “If I have App Formulas inside a physical column, how can I get those to update like a virtual column?” “How can I recalculate formulas with a push of a button?” All of these situations can be solved by implementing a Quick Update System inside your app. What is the Quick Update System? A way to update app formulas and recalculate v…

[SARO_Pruebas]

Thank you for this one!

Problem solved!