Numerical Formula Field not saving a value after closing the record.

Background: I am creating an easy way for my office to record the amount of supplies we have in the office at any time. To do this, i have created two tables that will work together through a relation...