Running Inventory ... just not getting it

[surfaceeffects]

Hello everyone.. First, thank you all for sharing your knowledge in this forum. Now my issue. I need to have a running total of my powder coat powder. I need to be able to have a starting amount then as it's being used, i have to be able to subtract the used amount from the start and carry that modified amount over for my next project. I know this is basic, but i just can't seem to figure this out. Yes, i'm very much a Newbie but i'm giving it my best. I have 3 tables, 1 for Customers, 1 for Jobs and 1 for the Powders. I can get the Customers on the Job layout (layout #4) and the Powder, but i can't seem to figure out how to get the running powder totals to calculate correctly and carry over for the next project. I need to be able to select the powder, put in the used amount then have the Remaining Balance show up on that same Job page. I've attached what i have so far and hope that someone can help out. Thank you for any time possible...

Inventory3.zip

[Genx]

Hi there and welcome to the forums

This is what you are trying to do as i understand it:

Have a begining amount of powder

Have an end amount of powder which equals basically your begining amount minus all powder you have used in your projects.

What we have to do is to call a function called "Sum()" from our powder table and add one additional relationship in order to isolate each particular color of powder in this case (see the attached file).

Basically what we do however is get the total of all powder used in records that match any powder color in question... Just see the file, i'm not that great at explaining things this way. Things i have changed are in blue (note the relatinships, the change in calculations, and the change on your GUI layout).

Hope this helped out a bit.

~Genx

Inventory3.zip

[surfaceeffects]

Hello and Thank you Genx!! That is exactly what i was needing. I had tried the Sum() function but had it in the wrong calculation. Now i can move on and work on adding more functionality to this DB. One day i hope to be able to help another in need.

Thank you,

Curtis

[Genx]

No problem and the thanks is always a bonus, good luck :)