Filter on enum column with ref value

[plafontaine]

Hello,

I have a "valid if" condition on an enum column : 

[Column Test]=Lookup([_THISROW].[Column Ref],"Table Test","Column Ref Table Test","Column Test table Ref")

Rather than doing a "valid if", when i add a new row, I would like to display only eligible values ​​in the enum column on my view to add.

How can i do that ?

Thanks

[T_I_Phong]

If I see it, You can try this formula at Valid if:

SELECT(table_Ref[Value_Enum_column],[_THISROW].[Code] = [Code])

[plafontaine · Accepted solution]

Hi, 

Thanks for your response.

I did this in the auto compute/suggested value : 

select(table_ref[Key],in([Code],[_THISROW].[Code]))