Advice on Related records best practice
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.