Page 1 of 1

Need to link two tables using dreamweaver cs4

Posted: Wed Feb 09, 2011 4:30 pm
by cnl83
I created a tabase with two tables.

1) Customers
2) Software

My customers form adds data to the customers table, but on my form I want to assign one or more pieces of software to that particular customer. How do I link up the tables to work that way? My customers table has a unique id.

Im using dreamweaver and php my admin

Thanks in advance

Re: Need to link two tables using dreamweaver cs4

Posted: Wed Feb 09, 2011 4:57 pm
by MindOverBody
Every software should have it's own unique ID. When costumer picks software in form, software's ID should be stored in customers table in specific column.

Re: Need to link two tables using dreamweaver cs4

Posted: Wed Feb 09, 2011 7:58 pm
by cnl83
Keep in mind that I will be adding software products regularly. I'll add the software types and brands before attaching a record to the customer profile.

I have attached an image to show what I have in mind. How would I go about achieving this?

What about using internal relations in phpmyadmin.