I’m well new to FileMaker.
I have two tables: Projects and ProjectLineItems. One Project record is related to many ProjectLineItem records. Each of the tables have a ‘Status’ field, where the status of the project or line item is selected.
How can I make the status of the project change automatically to ‘Complete’ when the status of all the related line items has been set to ‘complete’?
Many thanks in advance.