Membership database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham - 14 Dec 2004 16:23 GMT

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

Reply to this Message

Allen Browne - 14 Dec 2004 16:52 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I would like a suggestion on the best way to design a membership database
>in
[quoted text clipped - 12 lines]
>
> Thank you in Advance for any ideas you can give me

Reply to this Message

Jeff Conrad - 14 Dec 2004 17:07 GMT

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

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

> 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.
[quoted text clipped - 21 lines]
> >
> > Thank you in Advance for any ideas you can give me

Reply to this Message

Allen Browne - 15 Dec 2004 14:53 GMT

Okay, finallly got the web page written to go with the sample database:
http://members.iinet.net.au/~allenbrowne/AppHuman.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Nice sample Allen!
> This will definitely help with a project I am working on.
[quoted text clipped - 3 lines]
>> assign tasks/donations/memberships etc to either an individual or a
>> family.

Reply to this Message

Jeff Conrad - 15 Dec 2004 16:39 GMT

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.

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

> Okay, finallly got the web page written to go with the sample database:
> http://members.iinet.net.au/~allenbrowne/AppHuman.html
[quoted text clipped - 6 lines]
> >> assign tasks/donations/memberships etc to either an individual or a
> >> family.

Reply to this Message