I have tables as:

t_stock.dbf:

stock_id stock_desc
-------- ----------------
10001 Bottle water

t_unit.dbf:

stock_id stock_unit
-------- ----------
10001 Bottle
10001 Dozen
10001 Box

in the invoices, I use combobox:

RowSource: select stock_unit from t_unit where stock_id=vInvdetail.stock_id into curs temp
RowSourceType: 3 - SQL Statement

The problem is, in network environment with lot of clients, it's pretty slow, it takes 30 seconds for combobox to show up the list.

any suggestion where I can speed up the list?

thanks for the help.