>>>Hi Jhon. I'm developing a CS system (inventory and purchases with VFE) with SQL 7 and VFP: there is a 15000 items list and the customer wants a complete combo to choose the items in the purchase order. The list uses a whole minute to show ( is a WAN connection) and they really DO want to see the entire list because the operators are mostly untrained employees. How can I optimize the time? BTW the articlles master is updated very often...
>>>
>>
>>You might want to apply the technique I described in another message: Replicating the data from SQL -server into a VFP database. This way you ensure that every update is also updated within your local VFP table and have the performance advantage of the VFP local database engine.
>
>
>Hi Walter: Could you tell me the date of the message and the thread?
>TIA
>>
>>Walter,

Same thread, this sunday or saterday. But there is no addition information about this subject, though John, seems to have an objection to this approach, you might want to check this first.

Within SQl server you can replicate changes of table to another database (even a VFP database) so your changes to those tables a automaticly reflected in your VFP database.

Walter,