wynnewade

How do I list the name rather than the primary key of a related table in a dynamic table? One table holds the value of DealerID which is the foreign key for the dealers table. Another table holds the warranty replacement information for a return product. When I list that recordset in a dynamic table, the DealerID shows. I want the dealer's name instead. Any help is appreciated! Jon

I have a multi-part submission form for a support application for us, the manufacturer - the reseller's information is submitted, the customer's information is submitted, then the warranty support information needs to be submitted. How can I retrieve the CustomerID after I insert a record into the customer table in mySQL and pass it to the CSQdetails.php page? Thanks, Jon