iterative query

[rythem]

I am trying to do the following:

1. every time i enter something in the inventory table, i want it to be able to iteratively check for any avaliable stock and update the quantity instead of making a new entry every time.

2. Also, every time i do a requisition, it must "Subtract" that amount from the inventory table. (and update the inventory table). It however must give an error when the quantity requested is below the avaliable.

3. Also, every time i do a reqisition, it must check the left over quantity against my reorder point and populate the reorder table.

Please help.

 

[Pat Hartman]

Do some searching here for other thoughts on inventory. You will find that the majority recommend the transaction method. There is no auditiblity if you simply update a running balance. In addition to violating third normal form, it is a risky method since it is quite easy to mess up.