Our client has a really abnormal requirement and we are having troubles trying to implement it. They need a grid with a search/filter control. The catch is that when they search they want it to jump to the first record that is closest to their match.
For example they search for "MC" where the valid values are "AM", "DC", "MA", and "ZA" the selected record should become "MA". If it's on a different page then it needs to change the grid page.
We tried using the "Google-Like" filtering, which could possibly provide an alternative; however, there are way too may records to populate a drop-down list. There are approx. 10,000 records in the grid.
We are open to nearly any solution as this component is the single most important feature for this project.
For example they search for "MC" where the valid values are "AM", "DC", "MA", and "ZA" the selected record should become "MA". If it's on a different page then it needs to change the grid page.
We tried using the "Google-Like" filtering, which could possibly provide an alternative; however, there are way too may records to populate a drop-down list. There are approx. 10,000 records in the grid.
We are open to nearly any solution as this component is the single most important feature for this project.