I’m trying to find a way to do this so it’s all automatic. This is probably so easy, but I’m just not getting it.
I have a Locations table, Location1, Location2, Location3.
At Location1, inventory needed is Knives 10, spoons 10, forks 10
At Location2...