>>at the time of purchase/sales data entry i am showing balance stock :
>>
>>select itemcode, sum(iif(type='purchase',qty,-1*qty)) as balance from inout group by itemcode into dbf bal
>>
>>it is showing same value to all users, not add/less the qty of buffered records.
>>
>>warm regards,
>>mk.
>
>??? Did I say something different? Maybe you're seeking for new 'with buffering=.t.' clause of select-SQL.
>Cetin

No, I don't hink that would work for him. "WITH BUFFERING" would only allow the user to query their own buffered data, not another workstation's.