cnl83
asked on
Trying to get some database advise for linking tables or a better method
If you goto http://realitguy.com/helpdesk
username and password is: admin
Click customers, then select michael scofield (or anyone).
It take you to a page that shows all the details about that particular customer. The table that the data is pulled from is called "customers".
Now I want to add some items to these customers. Lets say the customer has 10 trucks. I want to be able to display that this customer has 10 trucks on the customer details page. Some customers may have more than 10 and some may 5 trucks and 5 cars.
So to create this feature, I think I will have to create another form, and a new table called "assets". How do I link my customers with the assets table? Do I create a a field in assets called "cust_id" and insert the customer's id in that field? or is there a better method?
username and password is: admin
Click customers, then select michael scofield (or anyone).
It take you to a page that shows all the details about that particular customer. The table that the data is pulled from is called "customers".
Now I want to add some items to these customers. Lets say the customer has 10 trucks. I want to be able to display that this customer has 10 trucks on the customer details page. Some customers may have more than 10 and some may 5 trucks and 5 cars.
So to create this feature, I think I will have to create another form, and a new table called "assets". How do I link my customers with the assets table? Do I create a a field in assets called "cust_id" and insert the customer's id in that field? or is there a better method?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all your help. This worked perfectly. Once I created that field to capture the customer id, it was easy. Dreamweaver's wizard makes this clean and easy.
Excellent. DW helps you get started but you will quickly reach the limit of the built in behaviors. Once you start coming up with applications that the built in stuff can't handle, you will either need to learn a bit of php so you can hand code stuff or you buy extensions for Dreamweaver to handle the more advanced stuff with wizards.
ASKER