Show the most recent records.

[Gannett]

I have several tables linked together to a parent table(baseline2).
My form draws from these other tables which have IDs that match up with IDs in baseline2. When I search through my records I need a way to only display the most recent information. If it could be done some way with the dates(which are in every table and attached to the data when it was received).

 

[Rich]

Order the date field descending

 

[Gannett]

I was thinking about eliminating all others in a form view while still keeping the old info in the tables.
Is there something like:
sort by ID DATE(desc) if first.id then keep