Avoiding Multiple IDs
| From: | Steve Fitzgerald | Date: | Wed, 01 Aug 2001 20:33:17 +0000 |
| Subject: | Avoiding Multiple IDs | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10971@lists.php.net to get a copy of this message | ||
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.