AnsweredAssumed Answered

How do I check the status of the related records?

Question asked by tony-v on Oct 28, 2016
Latest reply on Oct 31, 2016 by tony-v

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.

Outcomes