What is the best method for avoiding multiple ids for the same information.
For example: I have a table name company that has unique ids. The CompanyID are tied to a table name contacts which have unique ids (ContactID). The problem seems to be that if I add a contact with an existing CompanyName then I will get multiple ids for the same CompanyName.
I've considered using a drop-down menu for CompanyName when adding/modifying contacts, but it seems as if I might run into the same problem of multiple ids.
For example: I have a table name company that has unique ids. The CompanyID are tied to a table name contacts which have unique ids (ContactID). The problem seems to be that if I add a contact with an existing CompanyName then I will get multiple ids for the same CompanyName.
I've considered using a drop-down menu for CompanyName when adding/modifying contacts, but it seems as if I might run into the same problem of multiple ids.