I have a great database started with all the tbls and qrys but I'm stuck..
I need to adjust my inventor trough a "backflush" type of transaction
I Have 10 pieces of Part "A". I want to move 8 pieces of Part "A" from Location "1" to Location "2".
Need to add the 8 pieces to Location "2" and deduct the 8 pieces from Location "1" leaving 2 pieces of Part "A" in Location "1"