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 relationship. The first table i made is simply called "Supply Records" and is meant to simply have the name of a certain supply, as well as the quantity that we have of that supply at the start of the current month.
The Updated quantity field is a formula field used for later on....
The other table i made is the Supply Management table and is used to track individual supply orders. I have it set so that this table is a child to the Supply Record Table, and when someone intends to add a management record they will link the record to the correct supply in the supply record table, this will pull the current quantity of that supply in the office and from there the user will fill out the information in the form to indicate an added or loss amount of that supply.
Total Quantity in Supply Management is obtained from Supply Record and will use either the Total Quantity field or the Updated Quantity field for its value depending on the date that the order is created.
Now, my problem lies with the Current Quantity formula field, basically adds the value of the Quantity Received to the total quantity, and then subtracts the value of quantity used. This total is the most important value as it is meant to update how much of a supply we have left after any order, however after the supply management record is saved, the value in the Current QUantity field is blanked out and holds no value (even though it DID display a value while editing).
So, my question is, why is this happening? one thing to also note is that sometimes the value WILL be saved after saving, but once you back out onto the main page for the table the value will disappear again.
The Updated quantity field is a formula field used for later on....
The other table i made is the Supply Management table and is used to track individual supply orders. I have it set so that this table is a child to the Supply Record Table, and when someone intends to add a management record they will link the record to the correct supply in the supply record table, this will pull the current quantity of that supply in the office and from there the user will fill out the information in the form to indicate an added or loss amount of that supply.
Total Quantity in Supply Management is obtained from Supply Record and will use either the Total Quantity field or the Updated Quantity field for its value depending on the date that the order is created.
Now, my problem lies with the Current Quantity formula field, basically adds the value of the Quantity Received to the total quantity, and then subtracts the value of quantity used. This total is the most important value as it is meant to update how much of a supply we have left after any order, however after the supply management record is saved, the value in the Current QUantity field is blanked out and holds no value (even though it DID display a value while editing).
So, my question is, why is this happening? one thing to also note is that sometimes the value WILL be saved after saving, but once you back out onto the main page for the table the value will disappear again.
