Automatically select value in other combobox

Nishapd · April 24th, 2009, 02:13 PM

I have two combo box in a page. (number, name) and both of their values are coming from a databse and both of their information is related with each other.

for e.g
number1 name1
number2 name2
number3 name3

When user selects value from number dropdown, it should automatically selects its related name value.
Also when user selects value from name dropdown, it should automatically selects its related number value.

Can anyone please help me how to do this in Classic ASP.

I really appreciate your help.

Old Pedant · April 24th, 2009, 05:25 PM

You don't WANT to do this in ASP. You want to do it IN THE BROWSER, using JavaScript.

As simple as this:

Code:

<form>
<select name="first" onchange="this.form.second.selectedIndex=this.selectedIndex">
<option>number 1</option>
<option>number 2</option>
<option>number 3</option>
</select>

<select name="second">
<option>name 1</option>
<option>name 2</option>
<option>name 3</option>
</select>
...
</form>

...

This assumes that the options in the two <SELECT>s are related element by element. If it's more complex than that (e.g., maybe the values in the second select are arranged alphabetically?), then the JS code will be longer. But it still won't be complicated.

So if the above doesn't work, show a sample of your *REAL* <SELECT>s.

Nishapd · April 27th, 2009, 09:19 AM

Thanks for the reply.

Can you please tell me how to display text in another text box when I select some value from one dropdown ?

Nishapd · April 27th, 2009, 10:13 AM

Can anyone please tell me how to display value part of the dropdown in another text box ?

Old Pedant · April 27th, 2009, 04:40 PM

Just the value as it is in the <OPTION>??? Any reason to do that, when it is showing as text on the page?

But yes, it's very easy:

Code:

<form>
<select name="selectField" onchange="this.form.textField.value=this.options[this.selectedIndex].text;">
<option value="">--choose one--
<option value="1"> First one
<option value="2"> Playing a secondary role
<option value="3"> Trinity
...
</select>
<input name="textField" readonly> <!--the readonly is optional of course-->
...
</form>