I have a database with an employee table and a training table.  My members are required to keep their medical certification up to date.  I would like their most current record to show on their employee form.  What is the best way to do this?  So for example, an employee is an EMT, they attend training and the information is entered into the the training table (common field is employeeID).  I would like the course and expiration date to appear on the employee form so it is easy to see if their medical cert is current or expired.  Then three years later when they attend a recert class the fields are updated to the most current information.

---

Reply from Alex Hedley:

Create a Query of TOP 1 and order it so the latest record is on top then you can display that record
Or you could use a DMAX.