I am hoping I am just being slow today....
What I need to do is evaluate my current stock on hand against the parts needed to repair an item. If all of the parts exist I need to reduce the inventory and change the process code on the item so that it can go to the repair location. If there is not enough inventory for the repair I need it to flag it with a different process code and go on to the next serial number. If someone can give me a starting point to it I will try and take it from there.
It is in access 2007. I have attached a spreadsheet with samples of the 2 tables involved. The inventory table and the table listing what parts each serial number is waiting for.
Thank you all for your time. I will respond with any clarifications needed.