Table 1: List of Parts in Inventory
_pKey_PartNumber ( Unique Value)
Table 2: List of Part Bin Locations in Inventory Stacks
_pKey_BinLocID (Unique Value)
Table 3: Union : Stores Transactions about which Bins have been select to ties to specific parts
_fKey_PartNumber
_fKey_BinLo...