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
 

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
Dynamic Naming of Form Button 3
Accessing fields on Record Source without putting them on form/subform 4
Combo box search from main form to subform 1
Need help to incorporate procedural cursor logic into Access Form 0
How to Navigate Through Records in Alphabetical Order 2
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Contact Set Up for Personal Use 0

Top