An item may exist in multiple locations and this is a key feature of Trayse Inventory. The majority of locations will only have one item in it. That would make it a simple one-to-many relationship. However, some locations may have multiple items. Shipping, receiving, repair, in transit, scrap, etc. are some examples of locations that can contain more than one item. The Quantity table sits in the middle and functions as a join table.