EXECUTE TWO CONDITIONS AT THE SAME TIME IN VALID IF

[eSaico]

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 wrote:

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]))