I think I have a Many to Many join setting. I have a table of inventory items. I have a table inventory locations. One inventory item will be stored in multiple places, i.e. liquor storeroom, main bar, banquet bar, service bar. And there are main inventory items in the liquor storeroom.
As I read this, I would use a join table. The JOIN TABLE would have a pKey to that table. Then two foreign keys, one to Inventory and one to Storage.
What I am not sure of is the mechanics to simplifying the creation of this information. When I create the inventory item, would a portal to assign the storage locations do the task?