For simplicity, I have two tables, ‘Clients’ and ‘Orders’. ‘Clients’ contains Business name, Contact name and address. ‘Orders’ is a table of the orders of each client. I need to click on ‘Client’ and see their ‘Orders’
Clients
Business Name
Business Address
Orders
Business Name
Product
Size
I’ve got repeating groups set up to show a list of clients, and clicking on the client shows their orders, and it works great.
Problem
I need the field ‘Business Name’ in both tables to be synchronised. The ‘Business Name’ is editable and might be changed, there may be a typo that needs correcting or the business itself is sold and reopens under a new name.
I’ve poked around the workflow page and can’t figure this out. I can get ‘Clients’ to accept the updated name but can’t get ‘Orders’ to update the business name, so that if the ‘Clients’ business name is edited the ‘Orders’ becomes disassociated.