I need some advice please. I currently have a screen and the plan is to completely redesign it. But first, to tell what is does. It is a screen for managing orders, much lick a standard order form, name, address, phone etc plus a few other textboxes for aditiona information. However this screen is for an internal system, and there are also 2 buttons which allow the employee to select from a contact saved in the database or import a whole oreder, also saved in the database. Both of them open a popup with a table which allows paging, filtering and a single selection. Even more, for each row there is an edit link which opens another popup for a detail editing of the row(even though nobody uses this). From the technical point of view, it's a nightmare, it's slow, buggy and so on. So I have to come up with an ideea to have the same functionality but in a more simpler way.
I would like to completely drop the popups. But the database can be huge, so I can't use dropdowns, and also I can't pre-load the whole data when the user enters the page. Basically I need to help the user to allow the selection of one client from a huge number in the simplests and fastest way possible, based on some "filtering": (part of)name, zipcode for example.