>OK..... Did I ever say it was not? Regardless of whether it is an accepted practice or not, it is still NOT a trivial practice... That was and still is my point. i.e., easier said than done....
>
>>Well, AFAIK replicating data locally for speed is an accepted way to optimize >CS systems.....

FWIW I've found a solution that my customers like:

I have a view for the list but the requery is not done until the 4th character is typed or the enter key is pressed. That way it looks that they have the entire list but the query only returns a few records.

They are happy now.... Thanks