>>They bring up a form that updates information about recieved
>>orders. This updates records in the orders table about how
>>many items where recieved. It is also suppose to update the
>>qunatity on hand and quantity ordered records in the
>>inventory table, i.e. if 5 items are recieved on hand
>>quantity is increased by 5 and quantity ordered is decreased
>>by 5. This works most of the time. Occationally it does
>>not. What could be causing this problem. What should I be looking at.
>>
>>reprosss setting, buffering in form, buffering in data enviroment, etc.
>
>Are you using Buffering? If so, are you checking the results from TABLEUPDATE()? If you are doing two updates that must both go through, they should be wrapped in a transaction.

Application does do bufferiing. I did not write most if it. Not sure if it checks result of TABLEUPDATE(). HOW do I wrap multiple updates in a transaction?


>
>Do you have an error handler that might be quietly throwing away an update conflict error?

Error handler probalbly does not catch missed updates. If it did user would see an error screen (I think).