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
Need to link two tables using dreamweaver cs4
Moderator: General Moderators
- MindOverBody
- Forum Commoner
- Posts: 96
- Joined: Fri Aug 06, 2010 9:01 pm
- Location: Osijek, Croatia
Re: Need to link two tables using dreamweaver cs4
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
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.
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.
- Attachments
-
- form.gif (12.44 KiB) Viewed 187 times