I have a 'Contact' table and want a picker list to select from when they are associating that contact with a purchase.
My system is on a remote server and I am just not happy with the speed it takes to produce this list. (locally it is great, but when the contacts are over a couple hundred the speed is not acceptable).
I have tried several methods, the best I have visually (shown below) uses a filter portal of a global (search Existing Names). They can type in a name and hit the enter button which will narrow the list. They can also click on a name and it will then associate that contact with the sale.
Is there a 'best practice' method out here to do this fast and elegantly?
Any ideas that you have seen work in real world conditions are appreciated!