many-to-many

[dn841]

I tried to create a junction table with two primary keys. But when
try to enter data into the either of the two primary key fields it say
that there must be a related record in a parent table. But it seems t
me that there already is a related record in the parent table.

I'm trying to create a many-to-many relationship similar to the one i
the Northwind sample database which uses the Order Details table as
junction table between the Orders table and the Products table. Th
Product and Order ID fields in the junction table are both listed a
number types in the design view, so I don't understand how there can b
text in the Products field.

I use Access 2000. I appreciate any help you can give me. Thanks.

Dan (first-time message board user

 

[Rolls]

Your "junction table" is a relationship table, not an entity table. It uses
foreign keys (FK) not PK fields to link to the parent side.

You can have a PK field in this table to indicate that each row is a unique
relationship consisting of FK and other 1:1 fields.