Using a Self Join Relationship to List Single Incidence Of Duplicate Value

[Len]

Could anyone explain how I can make a list using a self-join relationship of unique (most recent based on descending Date and Time) incidence of a duplicate value? I am a chiropractor and want to generate a list of the most recent visit for all patients within a date range. patients each have a unique ID and the daily visits are identified via a text counter serial number field. I appreciate any help... Thanks!

[mr_vodka]

The self join in your visits table should be keyed on the PatientID key. The relationship can be sorted on the child side descending order based on the date. Now you can reference that related child date field on the parent's layout and it will display the latest date.