Your Inventory table should have a summary field which would be total of cost (maybe called s_total_cost). Then place the Inventory s_total_cost field directly on your Sold layout. As you move through your Sold records, s_total_cost should change to only display the summary of Inventory which matches your current Sold record.
Yeah think thats it, i'd got confused with the fields on the layouts
Yeah That works great.