I have a series of tables all related through PK/FK dependencies. Pretty standard stuff.
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.