I am using Access 2003. I have a parent table (tbldemographics) which is linked by a patient medical record number to a child table (tblfollowup) using a common field (MRN). For statistical analysis, I need to produce a flat-file "table" which contains the data from the parent record and the latest ( from the date field [DOF]) child record.

How do I produce a single record for each parent + latest child record?

Thank you!