How to populate the form fields from another drop down list

[Li Zhang]

Hello,

I would like to populate form fields from one drop down
list in the same page. The drop down list's value is from
SQL database. When user choose one of the value, I would
like to populate the all of the other fields from Database
according to the user's selection? How can I achieve
this?

Thank you very much in advance for your help.

Li

[only_me]

you either have to pass all the possible form option values across on 1st
page load then use some javascript to detect change of drop down and the
populate the form fields form teh already passed info - ask in a Client side
NG

or

use the OnChange event of the drop down to submit the form (javascript), and
then as a result of proccessing the form (other than by the normal Submit
button) send back the specific values to be plugged into the other form
fields based on current value of drop down control passed to form processing
page


"Li Zhang" <lizhang@cox.net> wrote in message
news:020901c37c1f$984ed740$a001280a@phx.gbl...

> Hello,
>
> I would like to populate form fields from one drop down
> list in the same page. The drop down list's value is from
> SQL database. When user choose one of the value, I would
> like to populate the all of the other fields from Database
> according to the user's selection? How can I achieve
> this?
>
> Thank you very much in advance for your help.
>
> Li
>