Action change status from one table to another

[DEVIMPLOY_Autom]

Hey guys... the idea is every time I change the *Prospeccao* or *follow-up* of the *Funil de Vendas* table, it changes these situations in the *Itens* table... Does the action only does it work if it's an edit on the Form instead of the Details ?

[Aurelien · Accepted solution]

Hi @DEVIMPLOY_Autom 

You may want to replace the one in your child table ("Itens"), with a virtual column.

The expression would be:

[Funil].[Prospeccao]

This way, the related "Itens" will always have the correct "Funil".

For reference:

https://help.appsheet.com/en/articles/1090811-dereference-expressions

[DEVIMPLOY_Autom]

I created the virtual column that pulls the status and then an action to launch the status in the items table ... thanks for helping me