View Single Post
  #2  
Old November 24th, 2009, 09:36 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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"?