I have a fairly typical situation with an orders table and a order details table. I am using a BE/FE design and I have placed a data macro on the after update event of the quantity shipped field of the order details table in the back end. The products table has a field name qtyOnHand and that is supposed to update every time someone enters a new line item in order details. The problem is this: I start with a product with say 1000 in inventory. I create numerous line items in different orders through a form and check the inventory. Occasionally the after update event does not fire and i'm left with a quantity on hand that has not been updated!
If you delete the quantity shipped then it will add it back to the quantity on hand. If I create a few line items, enter quantity shipped, then go back and delete each of those, theoretically I should be back at 1000 in inventory. This is not the case. Skipping entries appears random but perhaps its something else that is going on with my macro. Has anyone experienced this kind of behavior with data macros? I find it hard to believe that this could be a bug as it would render data macros completely useless.