Cyrus,
>>The Dropdown is the means to type in customer's Account number in an Order Entry form to locate the customer from the entire database. There is noway to limit that by indexing methods.
If the customer table is a dbf, the faster sites are probably benefiting from VFP's local caching which is the reason you see OK performance. This particular benefit of VFP sometimes isn't appreciated/remembered by people using C/S backends. Perhaps you can figure out whether/why VFP caching is different on the slow machine?
Even if you can, and realizing that this may be an established app that can be difficult to change: people here routinely pull customers from databases with millions of records with instantaneous performance. So I think people are disagreeing that the combo is the only way to achieve it. IMHO using the whole table every time will always create a risk of terrible performance, even in VFP, whereas a targeted query can continue to work fine across a 56K dial-up connection against any size database.
Would it be possible to add code to perform a query based on user entry to populate the combo with a handful of possible candidates rather than the whole customer base? That should work quickly every time.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1