We have duplicate account names (eg. Madison Police Department) since we have public safety accounts in different states with the same name.
We have recently realized that when we save a contact or a deal or send an email, the contact gets automatically moved to a different account with the same name. In other words, the contact module's Account Name field somehow gets updated incorrectly and links the contact to a different Madison Police Department for example.
For example, Bruce Collins gets moved from Madison PD (in Kentucky) to a Madison PD (in Tennessee).
Has anybody dealt with something similar? Any thoughts?
Here is a video: