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?