Thank you for your input Doug, but that did not work. User2 was still getting the qty unchanged.
Any more ideas?
I was thinking of creating a table that will hold the product code and the qty taken by an order. check this table evey minute and if a product has been there for more that 10 minutes and return it to inventory if that is the case. After I save the order I would remove the prodcut for this order from this table. This way I can just update the qty in one transaction when the user gets the product for the order and then save the order in a different transaction. This will allow me to reduce the quantity at the time the order obtained the product and increase it when the order is cancelled or if the user forgets or his/her computer crashes.
