Thread
:
How do I link one person to another in the same table?
View Single Post
#
2
November 24th, 2009, 09:36 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
Posts: 1,017
How do I link one person to another in the same table?
Your contact table ought to look like:
TblContact
ContactID
FirstName
LastName
etc
Then you need am acquaintenances table:
TblAcquaintenance
AcquaintenanceID
ContactID (identifies a Contact)
AcquaintedContactID (Identifies a contact ContactID knows)
If ContactID 21 knows ContactIDs 1,7, 32 and 47, TblAcquaintenance would
lool like:
1 21 1
2 21 7
3 21 32
4 21 47
Steve
"E289" wrote in message
...
I have a table of Contacts. Some of my contacts know other contacts, and I
would like to indicate that in their record. However, for Data Type, I
cannot create a drop down list of contacts from within the table to choose
from.
Any idea how to to this? Or, if this is not possible, can you suggest
another way to indicate "who knows whom"?
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]