Daily Product Balance

[Fabio_Nabuco_Co]

Dear all;

I’m building a management app, and I’m trying to build a “daily balance” of the goods produced in each day. For this, I have created a table “Entrances x Exits” of the goods produced, so when the products are registered in the table production, they are copied to the “Entrances x Exits”, and when they’re delivered, it will deduce from amount registered in the day it was produced. Therefore, I will be able to control First in, First out.

For this, I’m trying to creat actions, which are :

in which:

And to trigger that, in the table of expedition of products:

I was able to change the value to a pre-fixed value, but not yet to change the value of columns in another table with the value of the the row that is being input.

In advance, thank you for the support.

Regards;