EXECUTE TWO CONDITIONS AT THE SAME TIME IN VALID IF

[anonymous]

Hello, I need your great help please.
I want to run two conditions at the same time on VALID IF and have not succeeded so far.

First expression is the classic CRONOGRAMA[TEMA] for cascading dependent menu
And the second is to remove from the list an element already used CRONOGRAMA[TEMA] -
SELECT(MARCACION[TEMA], [ID] <> [_THISROW].[ID])

I would like these two expressions to be executed at the same time in said field

Thank you very much for your support.

[WillowMobileSys]

@eSaico

CRONOGRAMA[TEMA] - SELECT(MARCACION[TEMA], [ID] <> [_THISROW].[ID])

Your expression should simply be this one above BUT I see you are referencing 2 tables. Is that correct?

If so, are the [ID] columns truly the same between the 2 tables? If they are, you cannot compare key columns directly. Even though they are the same value, technically they are different keys.

However, you can compare them as TEXT, like so

CRONOGRAMA[TEMA] -
SELECT(MARCACION[TEMA], TEXT([ID]) <> TEXT([_THISROW].[ID]))