Victor,

>>While I try to avoid navigational lists in a C/S environment... there are two basic scenarios:
>>
>>For small lists, I still use combos. They get their data via a stored procedure. In some cases, I have had 4 or 5 of these items on a single form. The performance is lightening fast....
>>
>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.


Walter,