AnsweredAssumed Answered

Updating information based on the most recent evaluation

Question asked by CaitlinMcKelvie on Nov 1, 2013
Latest reply on Nov 1, 2013 by philmodjunk

Title

Updating information based on the most recent evaluation

Post

     I am creating a database where we have animals that get evaluated every two years. At these evaluations, they receive restrictions that they must follow. I have the database set up so that each evaluation is in its own table with the animal, the evaluation, and restrictions. Each animal, on its layout, then has its own information that includes restrictions. Right now, the animal restrictions and the restrictions that it receives that the evaluation are separate. I am wondering if there is a way to make it so that the animal's restrictions show the most recent restrictions from the evaluation. Thanks!

Outcomes