I’m trying to find the right expression for the following scenario:
I have a table named “Orders” (Parent) and the second table named “Loads” (Child). Both tables got a column named “Status”. So I want the status on the “Orders” table to change to “Delivered” if the "Loads have been delivered.
If there is still one load “Pending” the status must remain “Pending” on the “Orders” table. Only change to “Delivered” if all “Loads” have been delivered.
it’s cracking my head trying to find the right expression but I have failed in the attempt.
I would appreciate your help with this one Thank you!