How can I set or change type of participation for table relations

[r3]

I'm trying to create a self referencing table and I cannot figure out how to
get Access to let me create a relationship where the primary field key is on
the 'many' side of the relationship.

 

[Rick Brandt]

I'm trying to create a self referencing table and I cannot figure out
how to get Access to let me create a relationship where the primary
field key is on the 'many' side of the relationship.

By definition a PK has no duplicates so there cannot be "many" of the same
value.

 

[John Spencer]

If you are trying to set this relationship up in the Relationships window.
-- Add your table to the window twice.
-- Drag from the Primary key on one copy to the "foreign key" in the other
copy.



--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..