Updating information based on the most recent evaluation
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!