quickbase

I would like to have a connection between the SKU field in product list table and units field in Container table
 Relationship should similar to a lookup table but with another column for quantity, also after 
 I would like a similar function to sum if that will sum the units in this table based on SKU and status and show them in On water table or Manufacturing table depending on the status and i want a connection between Units and and SKU field within product list table 
 connection is while have something like a lookup table but with an extra column for the quantity this way I can enter SKUs and Quantity per FBA Shipment