Update a record in a table from a secondary form through a primary form.

[malfaro_2000]

I have this expression in an action SUMA call so that every time an item is entered through an ENTRADAS form, it adds the input entries SUM(SELECT( ENTRADAS[CANTIDAD], [CODIGO] = [_THISROW].[CODIGO] ) ) This is executed with another action EJECUTA SUMA call on the parent form with the following expression: FILTER("ARTICULOS", IN([CODIGO], SELECT(ENTRADAS[CODIGO], TRUE))) It works without problems, the detail that when edit the ENTRADAS entry, increasing the quantity, this is not reflected in the CANTIDAD column of the ARTICULOS table, can you help me so that the EDIT works?

[Rafael_ANEIC-PY]

Hello there,

You can set up an automation that watches your ENTRADAS table looking for edits to the CANTIDAD column with this condition:

[_THISROW_BEFORE].[CANTIDAD]<>[_THISROW_AFTER].[CANTIDAD]

and have it run the same action you're using.

Otherwise, you can REF up these tables and have the SUMA table run the sumation of the ENTRADAS in a virtual column with an expression like SUM([Related ENTRADAS][CANTIDAD])

[malfaro_2000]

Hi,

SUM table does not exist.

Do you mean action?

[Rafael_ANEIC-PY]

---

@malfaro_2000 wrote:

Hi,

SUM table does not exist.

Do you mean action?

---

Yes, my bad