populate dropdown list

[beekien]

Hi,can anyone help me?

I want to refresh 1 textbox value based on selected data in dropdown list.

both of them are from different tables.

Table A(dropdown list)
----------------------
ID Name
123 abc

Table B(text box)
-------------------
ID expenses
123 RM456

when i select the ID from dropdown list(Table A),I want the RM456 display in textbox.

can anyone have any suggestion?

best regards,
beekien

[jhardman]

in order to do this seamlessly, you will need to use some javascript or ajax. Remember that asp runs on the server, not the browser, so when the user makes a selection there is no obvious way for the server to know and execute any code. Does this suggest anything to you?

Jared

[beekien]

in order to do this seamlessly, you will need to use some javascript or ajax. Remember that asp runs on the server, not the browser, so when the user makes a selection there is no obvious way for the server to know and execute any code. Does this suggest anything to you?

Jared

Hi Jared,

thank you for your suggestion. I tried with xmlhttprequest to call another page. However, the 2nd pages failed to get the value that user's selection in 1st page.

do i use wrongly?

Regards,
bee kien