Hi Robert.

>I have a file to record the onhand inventory. eg. the onhand is 100 pcs, while I'm doing the sales, the other user (in network) has done it as well so the onhand now is 150 pcs. when I tried to update my invoice, the system rejects because the onhand value in the view and the table already difference (in my view = 100 pcs, in table = 150 pcs).

You can handle this through multi-user coding involving the OLDVAL() function. See the Multi-user and Data Buffering Issues white paper on the Technical Papers page of my Web site (http://www.stonefield.com/techpap.html).

Doug