stock level update

[compwizard]

Hello all,

Im having a bit of trouble getting my stock level update to work when an item is deleted from an hire.

I got an hire table - with stockselected = the quantity the company wants
I got a item table = with overall stocklevels for each item

When a item is selected in the hire table this will deduct the quantity from the hire table.this works but if the item is to be deleted during the hire taking place, this should update the quantity.

I have had a look at allen browne site but still struggling to get to grips with how to do it.

[NeoPa]

Your question is not very clear, but simply put :
When you add an item to a hire, then you must also subtract it from the stock level. When you remove an item, then you must also add it to the stock level.