>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

Locate with a small set of records in a view will be faster than having to create the index and use seek. If you have the index permanently then seek is faster.

If you have a grid and/or a timer that changes work alias before you do the seek, you could get the Open Table dialog. You really need to debug that and no worry about changing from seek to locate or views.