AnsweredAssumed Answered

Decreasing two values from two different tables with one table

Question asked by LeszekŁuczkanin on Sep 3, 2016
Latest reply on Sep 6, 2016 by tsplatypus


I have one CHILD table (operations) to check out my incomes/outcomes. It works pretty well.

If I give a loan it is outcome, and then when it is given back, I write it as an income. Same with donations.


But I have another category - ITEM. Here is the story:


I get 10 bears and a 100 $ - it makes 10$ each. I also get 5 birds and 20 $ - it makes 4$ each. I have to give it away.

I gave out 1 bear and 1 bird to my brother, 2 bears to my mother, and 1 bird to my kid.

I want to have an updated record to know how many is left to giveaway and I need to know how much money is still to giveaway. So I need to update ITEM table and also update my OPERATIONS. I would like to do it with my OPERATIONS table which i use to note all my incomes/outcomes.


How can I do that? Is it possible?