I've been struggling with something and well I think I've searched everywhere to find no solution.
I have 2 tables. One with distributors, and another one with instruments. Each instrument is related to a specific distributor and a distributor can have several instruments assigned.
What happens is that sometimes an instrument might be assigned to another distributor, already on our database. How can I change that? I tried to change the key field and the distributor name field but instead of adding it on a already existing one, it creates a new one.
Any ideas on how to solve this?