LeszekŁuczkanin

Changing two values in two tables by join table

Discussion created by LeszekŁuczkanin on Sep 3, 2016
Latest reply on Sep 3, 2016 by philmodjunk

IMG_0010.jpg

 

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?

Outcomes