Inventory in Multiple Locations
I am updating an inventory solution for a restaurant. I want to improve the count sheets. The problem mostly impacts the alcoholic items. Items are stored in the storeroom in back of the house. And there will be product at the main bar. There may be a service bar and/or a banquet bar.
In order to show up on count sheets I need multiple records? I was thinking a join-table of product-location. I have read about them. When I did they immediately popped up as a solution to this problem. But implementing this is what has me hung up. Any assistance would be appreciated.