How can I filter records that have one-to-many relationship? For example I have one person with ten to twenty notes. My query pulls up everything I need but I would like to insert this query as a subform that will allow someone to check off people they would like to view in a report. But the way the query is set up they would have to place a check next to Jane Doe ten times if that’s how many note records she has.
So I basically just want the name to show up one time even though that person has multiple records.
I hope this makes sense any other suggestions would be helpful.