I have a contacts database. This contains adults and children. The database records have relationships such as, parent/child/sibling, grandparents, uncles, nephews and nieces etc.
I’m trying to find a way to show related records to the one currently selected. My initial thoughts are to create a familyID for close family members that would show, parent/child/sibling records. I then though to create an relationID that could be used to show extended family members. My job is greatly helped by knowing who is related to whom.
As a secondary question, it would be nice to know what the relationship is between records such as Fred is brother to Jane, but my brain cannot fathom such deep logic.
To add a third question that will help expands brain cells to their maximum, I also need to see the records in relationship to households. For this I would simply create a householdID and show all related records that a part of a household.
Am I heading in the right direction? Any advice will be greatly appreciated!