Hi,
I have a need: only when all the records of the Movimag table are with the Evaso_SN=S field, I have to make the patch on the Tesdocum table, putting the Evaso_SN field with the value "N".
This script gives me this value when it finds even just one record in the Movimag table with the Evaso_SN field with an "S" value.
Instead, I would like only if all Movimag records are "S" shaped.
Where am I wrong?
Can you give me a suggestion?
Thanks in advance
ForAll(
Filter(
MOVIMAG;
NUMERO = BrowseGallery1.Selected.NUMERO
);
If(
EVASION_SN = "S";
Patch(
TESDOCUM;
LookUp(
TESDOCUM;
NUMERO = Gallery1.Selected.NUMERO
);
{EVASO_SN: "S"}
)
)