linking within tables on a form

R

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/sub form 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?
 
A

Anthos

Rather then having a primary person in the household, you could have
the family in a separate table,
Thus You can link the Family member to the Family table.

Let me know if this doesn't meet your criteria,

Hope it helps none the less,

Kind Regards
Anthony Moore

IT Excellence
 
Top