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
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…
1 Like