I have a database with 3 tables
Attendance (a join table for People and Events)
The people table contains fields for basic info, including the person’s title (Assistant Professor, Associate Professor, Professor). If I create a record for someone and a few years later their title changes, I create a new record for them with their new title. (The reason for this is because we look at our event attendance by position every year. So say in 2011 John Smith attended an event and was an assistant professor, then in 2014 he became an associate professor. If I change the title on his original record to associate professor, it’ll show he was an associate professor in 2011 when he was really an assistant professor.)
Now my question is how can I create a layout or run a report that will show me the event attendance records for a person no matter how many title changes they’ve been through? Using the John Smith example from above, I want Filemaker to group all of events John Smith went to when he was both an assistant professor and an associate professor.