I'm helping my local tennis club set up a small database to track all our members.  The complicating bit is, some of our members are "individual" members, and some are members in "group" memberships.

For instance, I have an "Adult (18 and over)" membership, as an individual.  However, a family of four people can join under a "Family" membership.  In that case, the membership form asks for a primary contact name and phone number, and then asks whoever fills out the form to list all the players who will be included under that membership.

Given these constraints, I'm having some difficulty figuring out how to set up Zoho with this.  We want to set things up so that we can track our overall memberships (which may be comprised of one or more people), as well as be able to manage all our members individually.

Right now, I have a "Memberships" form and view, and a "Members List" form and view.  I want to be able to set things up so that after the data is entered, I can go to any Memberships record and see which members are part of that Membership.  In addition, I want to be able to go to the Members List, find a given member, see which Membership they belong to, and see what other people are "with them" if they're part of a group membership such as our "Family" or "Couples" memberships.

Can anyone shed some light on how I can accomplish this?  I would be extremely grateful.