Select row of table value in enum list

[Adolfo_Enrique]

hello everyone, i need help with the following.

I am creating a form, where the user can select a work area.

From the work area I need to be able to list those operating technicians who can work in the selected area.
The work area for each operator is stored in the USUARIOS table, within the enumList AREAS_TRABAJO.

Can you help me find a solution to be able to list only those users that within the EnumList AREAS_WORK, contain the selected area?

with sql I could solve it with the IN syntax … maybe … but here I can’t figure out how to solve it … I appreciate your help!

[Marc_Dillon]

SELECT( ... , IN( [_THISROW].[area] , [areas] ) )

[Adolfo_Enrique]

Marc_Dillon:

SELECT( … , IN( [_THISROW].[area] , [areas] ) )

Exelente!!

but it doesn’t show me the dropdown to be able to select values ​​…

[Marc_Dillon]

The column not showing up is a clear indication that the valid_if SELECT is not returning any results. I’m not sure what the issue is here, sorry.