Remove different quantity amounts from multiple records?

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.
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How best to remove different quantities from multiple records? 1
Problem with SET & REF function 0
I need to display info from two different table into one query 12
Need Query to select records based off a Quantity column. 6
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
AT WITS END ON QUERY TOTAL 34
Page numbering with Merged Document and IF statements 1
combine like items in query 1

Top