Keys not matching on table relations

Discussion created by amerritt on Jan 24, 2017
Latest reply on Jan 24, 2017 by philmodjunk

Hi guys,


I have a series of tables all related through PK/FK dependencies. Pretty standard stuff.

Here's a screenshot to give you an idea of whats going on.Screen Shot 2017-01-24 at 11.14.35 AM.png

All of the relationships are =

Also note that this layout is using the Production Cost Sheet table, and if I do the same thing from the Sales People side of things it looks correct.

Can you give me any idea why the relationship is breaking between my Join table and Sales People table? You can clearly see that the ID's are not the same, but they should be. Also, this is the only record (that I know of) that's having this issue.

There IS an entry in the Join table for SALES000886 to Territory_ID::T00374, and when I remove that entry the relationship works correctly. I'd rather not have to remove the entry though, because I want that person associated with that territory, but I'd also not like it to overwrite the correct relationship as it's doing.