Drop-Down box with Too many entries
I need to tap into some experience out there. I have a classic Student/Class database. The classes layout, of course, contains a portal necessary for adding a student. The problem is that drop-down for students now contains about 64,000 names and its slow and not efficient in terms of finding the correct name.
What have folks used in the past to make this search more palatable for the one doing the data entry. I've considered adding a popover with another portal on it but it seems its verboten to have a portal inside a portal. Because I'm using the classic textbox over a drop down box for student name I cannot take advantage of just typing inside
I'd appreciate any tricks of the trade you could share...