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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to