Calculation and Sum for all Records

[Nikos Gewrgioy]

Hello,

 

I would like to make a relationship for sold items and for stock items to know how many items I have in stock.

I have two fields one for Quantity Potentiometer and one for Type of Potentiometer.

I make a calculation field with with name Sold 250k Pot with function: If (Pot type = "CTS 250k Audio Pot";  Quantity Pot) and then I have another one calculation which removes the Bought 250k Pot and I know how many Pots are in stock (Bought 250k Pot - Sold 250k Pot) and work perfectly but if I go to a new record the Bought, Sold and Stock fields didn't show me the remaining stock items or the bought parts or the sold parts from the previous projects.

 

Could you help me to solve this problem?

 

I have uploaded the database to show you the problem.

 

 

Thank you in advance

Projects.fmp12.zip

[Lee Smith]

Please attach your file here.

 

If you are having trouble doing this, let me know.

[Nikos Gewrgioy]

Hello Lee,

 

I have attached the file in my first post.

[efen]

The potentiometer details and records should be in a separate table rather than  in the projects table

[Nikos Gewrgioy]

Efen, how can I do that?

[Lee Smith]

I can't explain how you can do this better than Todd Geist does in his video and example file here Invoices