Hello, I am trying to create a "yes/no" field, that automatically updates when the conditions have been met. Presently, I have two tables that have been created and have a relationship between them. In the first table, is the "master" table. In the "master" table, I have a field called "All forms received?" which is of the data type "yes/no". In the second table I also have a field called "Form Received?" which is also a data type "yes/no" field. These fields are linked together through a submission number. In the master table, there are many "child" tables related to it. I would like the "master" field to automatically update when all the child fields have been checked. Also when we add another record to that submission number, the master field would have to review the new data of all of it's submissions and therefore could be updated again.
Is there any way to do this?