>>At a certain customer site (running Windows XP with 1GIG network gear), starting a form with a Dropdown Combo Control that loads 12,000 record, takes more than 20 seconds. Opening the same form on the Server, takes only couple of seconds.
>>
>>He has had the GeekSquad there couple of times and they've said the network is fast enough! and the problem is with the VFP application. Any suggestions ?
>>
>>Thanks .
>
>Your problem is not the LAN or Indexes. Comboboxes are not meant for 12000 records. The user is assuredly not going to browse all 12000. There are smarter combobox classes around that will bring down 10 at a time.

I agree that putting 12,000 items in a combobox is not a good idea. But why do you say that the problem is with the combobox?
If getting the records is fast on the server and slow over the network then I don't understand why the fact that the recordset happens to be consumed by a combobox is relevant.