Family table / Individual table?

S

Serendipity

Using Access 2003. I have a school volunteer database. Trying to figure out
the best way to design my tables. The database contains families where the
members have different reasons for being in the database, e.g., student,
parents in various volunteer roles, etc. Do I need a family table which has
only an Id and address information, and then another table for individual
information? I was told that the id in both tables should be autonumber. I
have been using something like SmiMel for the Melvin Smith family so that I
could quickly enter and find records. With hundreds of records in the
database, picking the family from a list before entering data would be
laborious. Please help me know how to proceed.
 
A

Allen Browne

Do you need to be able to contact/send mailings to anyone, including
student, parent, or family?

If so, download this example and pull it apart:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

As far as the primary key goes, you can use a text-based key if you wish. It
could get messy for trying to figure out the key to use for families
through.
 
S

Serendipity

Yes, each individual member might get a mailing, e.g., the for a birthday
party announce, the parents for a volunteer assignment a for sale item. The
link looks right on target. I am digesting it. Thanks.
 

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

Top