Unable to update main table basis sub-table values

Unable to update main table basis sub-table values

Hi

I have been trying various methods to do so for the last 2-3 days. Basically, I have the following structure:
1. Main table with fields: OrderID, customername, orderstatus
2. Sub-table with fields: ShopOrderID, shopname, shopstatus

OrderID and ShopOrderID are bidirectional fields linked to each other. It is a one to many relationship with multiple rows for each main row

I have managed to write a function that updates shopstatus basis update in orderstatus. I wish to update orderstatus if the shopstatus for all corresponding rows are updated. However, am unable to set that up. Could you pls assist me?

Regards