I’m going to try to simplify my issue as much as possible. Hopefully it will be clear enough.
I have 2 bases : Operations & Purchases.
In Opérations I have a table with all my Orders.
In Purchases I have a table with all my Suppliers.
Our orders are composed of several sub orders.
Each sub order has their own status, because they are managed independently.
The main order status is equal to the less advanced of the sub orders status.
I’m trying to update automatically update...