Problem: User needs to select a street name from a table of over 700,000 records. To populate the dropdown list of distinct values takes too long to process. Is there a way to narrow down the DB query for the list box based on the first character(s) the user keys into the selection box?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!