edlentz
Posts: 11
|
Posted: 02/28/2004, 7:05 AM |
|
I have a customer database in MySql, I have ccs/php. I want to be able to select from a listbox a customer and have that box enter all the pertinent customer data to the page. How can I do this? can someone point me in the direction of a tutorial or something?
Thanks
Ed
|
|
|
Michael Mikkelsen
|
Posted: 02/28/2004, 11:49 AM |
|
The Data Source for your list box will be the customer table in your database.
You will want to use JavaScript to submit the form when a user selets an item in the listbox.
Add a name to your form
<form name="myform">
and add this OnSelect to your listbox
OnSelect="document.testform.submit();"
Modify the Data Source for the Record Object by adding a Where statement so that when a cust_id is passed it shows the record for that customer.
Michael Mikkelsen mike@kccoupon.com
|
|
|
edlentz
Posts: 11
|
Posted: 03/03/2004, 7:55 PM |
|
I am a real newbie at this. Could you show me some code on how to do this?
Thanks
|
|
|
|