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?