Report on Checkboxes

[mattdunn]

Hi all,

I am making a contact database. In it, each person can be a member of certain groups. For instance, Joe Blow is a member of Activities and Newsletter. There are twelve such groups and I have made a checkbox field that contains all of them. When I run a report on group membership, Joe Blow will show up in Activites but not Newsletter. How can I run a group membership report where people in multiple groups will show up in those groups on the report?

The report I want to see would look something like...

Activites

Joe Blow

Newsletter

Joe Blow

I hope all this makes sense, I am a bit of a newbie.

Thanks,

Matt

[bcooney]

Your best approach is to make 3 tables: Contacts, Groups, and Membership. Membership is a join table, it contains the combinations of a contact and a group.

key fields are:

Contacts Table

_kP_ContactID

Group Table

_kP_GroupID

Membership Table

_kP_MembershipID

_kF_ContactID

_kF_GroupID

Then, in Contacts, have a portal into the Membership table.

In Groups, have a portal into Membership.

So, you can add a contact to a group or a group to a contact by adding a record to the Membership table.

Your reports will run from the Membership table. Lots to explain in a post, search for posts that discuss join tables.

[mattdunn]

Thanks for the tip. I will look into join tables and see if that is gonna do the trick.