AnsweredAssumed Answered

Sorting records from a related table

Question asked by annreese on Aug 2, 2018
Latest reply on Aug 2, 2018 by philmodjunk

I have a database with the following tables:

Patients

Monthly Notes

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?

Outcomes