I have a database with the following tables:
I am trying to create a list of patients with the most recent monthly note listed, if they have one. Since I want all patients listed, I created the list based on the "Patients" table so I would get the patients all listed once. I can't seem to sort the records from "Monthly Notes" so that the one displayed in the list is the newest one. Any ideas? Is it possible?