I am considering adding a FIND trigger to our system, but am not sure the concept will work.
We have a table inv_adjust that contains increments and decrements to inventory. Say I take 5 widgets from a bin in the warehouse, I insert a record in the inv_adjust table with a the widget id and -5...