Remove different quantity amounts from multiple records?

  • Thread starter Thread starter Cuda426
  • Start date Start date
C

Cuda426

I have a small Inventory DB, main field is Part Number. I am trying to remove
different amounts from different part numbers when you remove 1 item.
Multiple parts go into a welding bug. When one is complete, trying to go into
inventory and select "Complete Bug" and have it remove 1 from Quantity field
for part number 001 and remove 2 from quantity field from part number 002.
Field names affected will be [Part Number] and Quantity. If anyone has done
something similar, and help would be greatly appreciated.
 
I think it is better to record each tranaction separately using a field for
part number, actiodate, actiontype, and QTY. You then sum all transaction to
determine the balance by multiplying QTY by -1 if actiontype is withdrawal,
breakage, etc.
You might also have a field in transaction record to indicate serial number
where part was used and who withdrew it.
 
Back
Top