You need another table that has the following fields:
-
Link to another record
-type field linking to [Product Inventory]
-
Link to another record
-type field linking to [Warehouse Locations]
-
Number
field for the quantity
Your current {Product Inventory}
field in the [Warehouse Locations]
table should be converted to a Lookup, as well as the corresponding field in the [Product Inventory]
table.