Warehouse location adjustment

[tj63069]

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"

[orange]

Please show us your tables and relationships.

[tj63069]

Sorry it's too large to upload

[orange]

Have you considered compact and repair or zip?

Or just a screen capture and jpg of the tables and relationships?

[tj63069]

I did..dumped data but the best I can do is down to 800kb..300 too many for upload

[tj63069]

Hope this is enough