using database for multiple locations
I have created a database for keeping track of inventory in our warehouses. Right now it works great if it were only going to be used for one location. What would be the best way to expand it so that it could keep track of the inventory in multiple locations and maybe compile a total inventory amount? I have 4 different warehouses to track.