I have a "how would you approach this" question:
I have a customer number and customer name that I am using in a pop-up menu via a valuelist referencing a table in my database.
It is completely functional for my purposes. However, I have now learned that there will be 1800 entries in this table. OUCH!
What are possible ways I could narrow down this list and improve the usability of the system?
Should I use a different method to get them to enter the account number?