Trouble with Many-to-Many Relationship; Duplicate Values

[BDibz]

Hello,



I'm having trouble setting up a many-to-many relationship. I want each serial number to have multiple operations. I set up a table to relate them as many-to-many and turned off primary keys to allow duplicate entries, but I'm still having some error regarding this relationship. The attached pictures should give a pretty clear idea of whats going on.

Thanks

[June7]

So why is the link between the two serial number fields showing 1-to-1?

Make sure there isn't still an Index set in the junction table on the serialNumber field.


Advise not to give multiple fields exact same names.

[BDibz]

So why is the link between the two serial number fields showing 1-to-1?

Make sure there isn't still an Index set in the junction table on the serialNumber field.


Advise not to give multiple fields exact same names.

Turns out this was a little "artifact" from before I removed the primary keys on my junction and allowed duplicates. The old relationship was one-to-one, I had to delete and rebuild to make it one-to-many. Works now. Thanks.