I have 2 tables, the first with general information, and the second is a "notes" table. The tables are joined by a one to many relationship, one record in the general table, and infinite number of records in the notes table. I am creating a report and I want to have specific fields from the general information table, but only the 2 most recent notes from the notes table. Is that possible?
Thank you!
Amy