linking within tables on a form

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/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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking records within the same table 2
Combo box search from main form to subform 1
Copying data from form to subform 1
List box in main form AND in subform 6
Display record on Main Form from subform record selection 2
Separate Form 0
How can I check a record to be inactive 1
Table within a form 2

Top