Web Development
When I have fields (combo box drop down type), which are lookup fields for my table the query does not respond to a text entry it wants the number which my user does not know. How to get the display value not id vale ??
Thanx
by russ.julie Accepted solution
by tony hopkinson Accepted solution
There are two ways basically, you can add both the display value and the key id to the the combo when you populate it.
There's usually an overloaded version of add additem or addobject method to do that.
You could bind to the combox box in .net.
Or you could keep a list / array containing number and name and then use the selectedIndex property of the combo, to find the chap you want in your list.
The latter is my preferred method. Populate the lookup list from the query then the combo from the lookup list. Always if if I need the list of available values in more than one place.
This discussion is closed to new replies.
Sort by Trending