I am trying to make a simple sales table that will communicate with my inventory table to subtract what is sold and show me how much inventory I have left. I don’t understand most of the lingo…

Would you be able to post a screenshot of each table?

In your Inventory table, add a rollup field that aggregates the Sales table’s `{Quantity}`

field. For the aggregation formula use `SUM(values)`

Turn your `{Amount in Stock}`

field into a formula field that uses this formula `{Quantity Purchased} - {Name of your rollup field}`

So here’s the roll up field I made…

Then when I put in the formula for quantity in the sales section it says there is an error…

omg never mind! I got it!!! THANK YOUUU

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.