you are going to want a 'buster' table... also known as a many-to-many table....
so you have: contacts -------- Contact_Key Industries --------- Industry_Key Contact_Industry_assoc ---------------------- Contact_Key Industry_Key > -----Original Message----- > From: DeBerry, Casey [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 29, 2003 1:09 PM > To: '[EMAIL PROTECTED]' > Subject: Table design help > > > I have a small table that contains company contact information: > > Table: Contacts > Key > Name > Address > Phone > Email > Website > etc.. > > > What I need to do is associate the type of industry the > business servers > from a list of about 40 industries... My initial thinking > was to create > another table that contains all of the industries along with > unique key for > each. So table would look like > > Table: Industries > Industry > Key > > The problem is, some businesses server many different > industries. So my > question is, can I add another column to the contacts table that would > associate many different industry key's to the contact? What > is the best > way to design this database to talk with PHP? > > Thanks, > Casey DeBerry > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
