7 Replies Latest reply on May 11, 2012 4:50 PM by andypullen

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

    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