I have been following the access barcode inventory seminar to create a inventory system at my company. I have everything working well, except I am stumped on how to have quantities change on multiple tables for sending inventoy out and receiving inventory. I need to use invoice numbers on all incoming items, so each time I receive a shipment I have a new quantity received and quantity in hand which adds to the total. I can not figure out a way to have the quantity in hand total be reduced when an order is marked as shipped which should reduce the quantity in hand, but since there are multiple entries to a running total, I am not sure how to make that happen.. My tables are set up a little differently than the ones you made in the seminar because I had made them beforehand and inputed a lot of data. I just made minor adjustments to my code and queries to make everything else work.
It would be great if someone could point me in the right direction, I can also send my database if it would help better understand the issue or make it easier to solve the problem.
Thanks