calculated column from other tables

I have a parts table ("Parts" - key is Part Number) for a marine services shop, and would like to create a column documenting current inventory from two sources - a "Supplier Invoice Detail" table wh...