drop down not selectable

[rpatel3680]

i have my drop down filled with a bunch of terms from a query. the drop down has two columns. the second column is bound to a text box that fills up with the selection from the drop down. when using the form and select from the list some items are not selectable. instead they go to another value in the drop down. i have data like this:

column1        column2
--------------------------
artery         art
bloodvessel    art
bloodvessel    ven
...

so when i go to select the "bloodvessel" with "art" in the second column, it selects "artery" instead

how do i prevent this from happening?

 

[SydneyGeek]

Looks like you've get data issues. When you use a drop-down, the values in the bound column should be unique so the look-up knows what to pick. You have art going to artery and bloodvessel -- the first matching item on the list is artery, and that's what you get.

Denis