Flag most recent record in many to many details table

I?m building a medical surveillance application for employees working in a hospital environment, and are required to take a set of annual medical tests. The tables are: Test Types, Employees, ...