Influencing Checkboxes from other Checkboxes
I have three tables in a database for a biomedical research lab. One hold compounds, one holds information on batches of each compound, and one is for tests run on samples from each of those batches. In case of contamination or outliers, I have a check box to exclude the results of individual tests from the averages of those tests calculated for the compound. However, I also want to add a check box to exclude an entire batch and all tests run on samples taken from it.
Is it possible to check a box on the Batch table and have it check all the boxes for tests run on that batch? If so, how?
A potential problem is with the relationship structure: Both the Batch and Test tables are linked to the Compound table, so creating an easy relationship between the Batch and Test tables has been giving me a lot of trouble.