I’m trying to set up database that shows the relationship between boat brands and boat dealers (i.e., what boat dealers sell which boat brands) and I’ve run into a confusing problem.
One of the records in the boat brands table switches between 2 names - Sea Bass and Robalo - and I have no idea how to fix it. The brands are not duplicates nor are they associated in any way.
How can I fix this? This issue is affecting the data my boss needs to help move forward with a project.