I have foreign key tables within my relationships that are shown three times (3 instances, same table),since there are three fields in the primary key table that each relate to the same table.
For instance in the primary table there are fields for PUCarrier, LHCarrier, and DVCarrier all of which relate to a table called tblCarriers. I added multiple instances of the tblCarriers table and linked each of the three fields in the primary table to these instances. Referential integrity was not allowed and therefore Attachment 39698was not checked. However when I close the database and reopen all of the relationships from the three fields in the primary table are shown as relating to the first instance of tblCarriers.
Any idea why or what I can do to fix this?