Sorry, I'm sure this is a pretty simple query, but I can't seem to get it right, so any help would be appreciated.
Two tables, like this:
One to many relationship between Patient and Checkup. Every time a patient gets a checkup a new record is added to Checkup with the current date.
I'm wanting to select the records in Patient along with the highest (latest) CheckDate for that ID in Checkup
Seems simple enough but somehow I'm messing it up. Any clues for me?
Two tables, like this:
Code:
PATIENT
-------
ID -- Autonumber LongInt Primary Key
Name
Etc.
CHECKUP
-------
ID -- Foreign key to ID in Patient
CheckDate -- DateTime
I'm wanting to select the records in Patient along with the highest (latest) CheckDate for that ID in Checkup
Seems simple enough but somehow I'm messing it up. Any clues for me?