>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.
Do you have an error handler that might be quietly throwing away an update conflict error?