Hello All, I have been creating an inventory database for a small company that I started working at. This is a seed company and we store our product in steel boxes. As these boxes with product go through the plant they can gain and lose weight depending on the process. I have a database created with 4 tables. 1 with the product numbers and descriptions. 1 with locations in the plant where they can be stored. 1 with the boxes and the last one that stores all of the weight and location adjustments to each box based on the product number and box number. All of the relations are set up and working great.
The issue: I created a form that I use when the product completes from a process and it works well enough. The problem is that when I am updating the weights of the boxes I have to figure out the math myself from the start weight of the box to the output weight.
Ex: 3100 lbs to start 2900 lbs after/ for this example I would have to figure out the difference and enter -200 in the field.
I have been trying for days to figure out how to make this entry be something like this example: 3100 lbs to start 2900 lbs after/ enter 2900 and then it will populate the adj table with the -200.
Thank you for any and all help! (also, I am not very well versed in macros so my thought was just to populate a variable that is then passed to the table but have no clue how to accomplish this.)
EDIT:
Hello and thank you. I have attempted to attach my file. The structure for the file is this:
My form “MISC INV UPDATE” is updating the ADJ file with the data in the populated fields. The issue is that I am having to do the math to get the difference.
(From previous example) What I am shooting for is instead of having to enter “-200” in the weight column I would like to be able to enter “2900” and have a script or something run that does the math and enter’s “-200” in the ADJ table for me.
Does that make any more sense?