I have the following table. Orders (Main table), Picking, Rework, Packing.
All tables have the key “Order”. Operators enter their submissions in the Picking table and then enter a status e,g Pick Complete. Operators then enter their submissions in the Rework table and enter a status e,g Rework In progress and so fourth for packing. When the user saves the input how can this find the key in the Orders table and update the status for the order. (Using google sheets as my data source)