Linking records within the same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an address book documenting everyone as a single record. I am
wondering what a good way to linked those in the table who are family
members. I know one option would be to have a primary person in the family
(Head of Household) and create a sub table underneath for all the family
members, thereby eliminating the need for multiple addresses. However, in
this case everyone must have an individual record within the same table. Any
idea of creative ways to create the link?
 
Not precisely sure what you mean "linking". If you have an address field,
this should be the way to identify all of those individuals that fall within
a particular household.

If you are looking for a heirarchy table, then you will need ID and ParentID
fields which would allow you to identify the "Parent" or "Head of Household"
by putting a Null in the ParentID field, then, for all the other members of
that household, you enter the "head of households" ID value in their ParentID
fields.

HTH
Dale
 
Back
Top