robsuttonjr
MIS
I have 40,000 items I want to incrementally search. I have used a combo grid class but it is slow. (Slow because I use a filter.) I wonder if I am using the wrong appoach to gettting what I want. I don't need to edit the items which is what a grid would be helpful for. I just need to have someone type the item and find the matches available. What would be the fastest way to search the items in a combobox, using a list, table, array, or cursor? I need the list to show the closest matches to the currently typed text. Once item is choosen the item number is stored to a variable for other use.
Examples
Typed: 101
list shows
10100
10101
etc
10165
list shows
10165
10166
10167
Please help!
Examples
Typed: 101
list shows
10100
10101
etc
10165
list shows
10165
10166
10167
Please help!