AnsweredAssumed Answered

How do I list an individual's "Groups" from the current "Semester"

Question asked by andypullen on May 10, 2012
Latest reply on May 11, 2012 by andypullen

I'm working on a database for a church to keep track of contacts, giving and small group membership. Our small groups are semester based. I currently have a many-to-many relationship between groups and individuals, so that people can be in multiple groups, made up of multiple people. Anyway, what I'd like to do is use the list function to calculate what groups people are in for just the current semester. My relationships chart is below. Any help on the calculation would be very appreciated! Thanks!

 

relationships.jpg

Outcomes