Updating parent row information basis values in child rows

Updating parent row information basis values in child rows

Hi

I have been trying to update a field in a parent row basis values that are edited in the child rows, but been unable to get it working. To elaborate:
1. Parent table has fields - OrderID (unique id), customer id, orderstatus
2. Child table has fields - ShopOrderID (bidirectional field linked to OrderID in parent table), Shop name, shopstatus

Each parent row might have unlimited child rows linked to it basis the unique OrderID.

I have managed to update shopstatus basis changes in orderstatus. However, when I try to update orderstatus whenever the shopstatus changes, it doesnt happen. I have tried inserting update scripts in the OnSuccess section of the child table, User input section for the fields under the parent table, writing a function etc, but seem to have hit a brick wall. Any assistance would be appreciated.

Thanks.