Linking records within the same table

[Rose]

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?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Selfjoin2k.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Dale Fye]

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