OK need some help on this one, I have the following: I am using MS access 2016
I have stores: A,B,C,D
All four stores have the same inventory type for fruit they have lets say: apples, oranges, plums and bananas
and Drink they have coke, sprite, Fanta, Pepsi
What i would like to do is:
1. have an inventory for each store with each item and QTY
2. I want to use a form or table that will subtract the QTY of apple and coke that was purchased from store A or oranges and Sprite from store B
I get lost cause i am not sure how to write a query or SQL the will take the store and the fruit and the drink into consideration so it know how much to take away and from what.
Any help would be grerat.