[SOLVED] Change form fields based on dynamic dropdown...Please Help

[cmaclennan]

Hi Guys, I'm hoping once again in your infinite wisdom you can offer some help and insight for me, I have a form that one section of I would like the option of a dropdown menu to fill in fields that have already been entered into the database (Order form customer data is stored) to speed up the process for repeat customers.

 

Using dreamweaver and there recordsets etc I have been able to put the dropdown in place pulling the proper info for it and then I set the some of the fields to pull the corresponding info but it appears just to take the first item from the drop down and not change at all. Its entirely possible im going about this the completely wrong way hoping someone can shed some light for me. I've attached the file as it is at the moment.

 

Thanks in advance.

 

[attachment deleted by admin]

[phpdragon]

This is a solution for ajax, check the following post for how a select box changes the contents of a div tag, this example populates another select box with a list of states  based on which country was selected in the first select box, you can modify that to have the div tag include the contents of your form to be modified and the query to collect the data.

[elbowgrease]

Where is this information? Is Spry ok for this?