AnsweredAssumed Answered

Advice on Related records best practice

Question asked by InvectusIlumni on Jan 7, 2011
Latest reply on Jan 7, 2011 by InvectusIlumni

Title

Advice on Related records best practice

Post

Hi guys -- 

This is a follow-up question to a series of previous questions I've already asked. To those who helped me in the past, I hope I'm not becoming a pain.

I have a CONTACTS table that tracks  church members contact information. In some cases a contact record could simply be an entire family which will be made of many existing contacts. Since families and contacts have most if not all attributes in common, I was wondering it will be better to create a table occurrence of CONTACTS that could be named FAMILIES and create a relationship to it from CONTACTs or instead of a separate table.

The reason I would want to have a FAMILIES-<CONTACTS relationship is to record many family-specific  information like household income, greeting (for mailing etc.) and to better determine the kinship between church members. Here's my graph and I know there must be a more efficient way of drawing it. I would also appreciate any feedback if anyone notice something wrong with the graph.

ERD.jpg

Outcomes