I have a long list of items in a database. I would like to build drop-down menu dynamically. The problem is that the list is over 14,000 items.
Has anyone dealt with a similar problem? Any suggestions on how to go about it?
Yes - That would be bad to put all contents into a single drop down. I suggest that you limit the amount of contents for 1 drop down. If the needed content isn't in that drop down - Redirect to a page that shows the next (lets say) 500 more items or whatever. Even better - Just let users put in a search query and search the closest results.
Funny, that's the only solution I was getting close to: search for a %LIKE term on page one then display a list of possible close matches, select one and sent ID of the selected item back to form.
