Membership database


G

Guest

I would like a suggestion on the best way to design a membership database in
regards to single and family memberships.

I am taking over this database from some one else. currently members are
listed by the main person who is interested in the organization, and a space
for spouse's name is on the form. However now we have some of the spouses
becoming more involved and on the same committees as their spouses. at
first I thought just create a new member, but how do I like that with their
spouse so I can still keep track of membership dues, (Family memberships are
$40, while single memberships are$25)

Thank you in Advance for any ideas you can give me
 
Ad

Advertisements

A

Allen Browne

You need the individuals and the families in the same table, so you can
assign tasks/donations/memberships etc to either an individual or a family.

There's a downloadable example of how to do this at:
http://allenbrowne.com/human.zip
Sorry: there is no web page explaining this, but it does demonstrate the
basic technique. It's around 40kb (zipped), and works with Access 2000 or
later.
 
J

Jeff Conrad

Nice sample Allen!
This will definitely help with a project I am working on.
Thanks for sharing.
 
Ad

Advertisements

J

Jeff Conrad

Thanks Allen, that is very helpful.
I'm trying to build some table structures for modeling a "guest log" for food service operations.
The log could be used for many different purposes, but modeling the family structure
relationships/memberships was a little puzzling. Your sample should definitely help. Thanks again
for sharing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top