I use this in the code:

select stock && stock.dbf
mkey=this.value
seek mkey order stock_id

with 10+ clients doing invoicing at the same time, I always got Open Table screen pop-up.
(is there any limitation with VFP, or .dbf in multi-users environment?)

then I think if I use view instead of table, it might help.

I changed it to:

select v_stock && this is view
mkey=this.value
locate for stock_id=this.value

I haven't test this yet in the real situation.

a) will it get rid of Open Table pop-up screen?
b) will it slower? since it's locate instead of seek.
c) any suggestion?

thanks for the help