ListBox value

[ekendricks]

I have a listbox "Employee" that is pouplated with a SQL stmt. In the SQL stmt, I can SELECT ID, Name, Dept, Etc. The listbox shows the "ID - 25" and "Value -Name". I do not need to see any additional information in the listbox, but I need a javascript function to populate a textbox "Dept" with the "Dept value" that was retreived with the SQL stmt. Ernest

[cdengler]

More information required here.. Are you saying that you already have the listbox populated, and that when a users selects one of the items in the dropdown that you want that item's text data to be populated in a separate text box?

[ekendricks]

Correct: This list box is already populated using a SQL stmt. User can currently select an item in the dropdown. The fields in the list box are ID=1d, and Value=Name which is displayed to user. The SQL stmt returns: ID - Name - Dept. I need an onchange event that will populate another text box "Dept" with the 3rd column of the list box "Dept". Thanks Ernest

[cdengler]

Ok, if I understand this, what you're saying is that you have three values... the ID, the name and the Department. And now based upon which one they select, you need to populate another area with the department value. I would create a Javascript array on the page populated when the SQL populates the dropdown. The array would contain the IDs of each dropdown associated with DEPARTMENT. On the OnChange, have the script look up the value of the selected item in the dropdown, get the department value, and populate the other area. Make sense?

[ekendricks]

Yep... you understand..... Thanks for the reply..... Now I just need to find samples or figure out how to do just that.. Thanks Ernest