>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...

TIA