I agree with Tamar - I think there was a typo in her post though and that she meant you may need an "Index On stock_id Tag whatever" for your table t_unit


hth
-Stefan

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