Help..Newbie Multiple entries link to one field

[MsJBossy]

Hello,

I am have just built two tables (1) for my contacts, (2) for organization
which contains information related to each entry. Now I want to link
individual contacts to each organization. The problem is I have more than
two and three people for each organization. How do to I link more than one
person to each organization. Please HELP ASAP.........

 

[tina]

if each contact (person) is associated with only one organization, just add
the primary key field of the organizations table, to the contacts table as a
foreign key. then link the table fields in the Relationships window and
enforce referential integrity. if one contact may be associated with many
organizations, and one organization may be associated with many contacts,
then you need a linking table, as

tblOrgContacts
OrgConID (primary key)
OrgID (foreign key from organizations table)
ContactID (foreign key from contacts table)

if you're not familiar with the terms "primary key", "foreign key", "linking
table", then read up on relational design principles. for more information,
see http://home.att.net/~california.db/tips.html#aTip1.

hth