help!!! referential integrity problem

[dan]

I have a couple of tables: People and PeopleContacts

People table:
PersonId
Name
Address
etc...

PeopleContacts table:
PersonA
PersonB

The People table is a general contacts info table.
The PeopleContacts links people with other people - a kind
of "here's a list of people that this person is associated
with" kind of table.
So PersonA is a reference/foreign key to People.PersonId
and so is Person B.

Now when I go to the Relationships section within Access I
try to implement this relationship but it only allows me
to create one of the links between People and
PeopleContacts, e.g.,
PeopleContacts.PersonA->People.PersonId

It won't let me create the additional link for
PeopleContacts.PersonB->People.PersonId.
(It does let me change the relationship to PersonB instead
of PersonA, just not both.)

Is there a way around this? If not, then how can I
enforce referencial integrity without having to create a
form and some VBA???

Surely Access can do this?

Cheers,

Dan.

 

[Joan Wild]

Add the People table a second time to the window. It'll add a 1 to its
name, but you can create the second relationship to it.

 

[dan]

Thanks!!!

-----Original Message-----
Add the People table a second time to the window. It'll add a 1 to its
name, but you can create the second relationship to it.

--
Joan Wild
Microsoft Access MVP




.