Enum select from 2 different colum

Hello,
i have an enum column [grade]
i would like to filter the choices by key.

table1 has [key][grade1][grade2]
table2 has [key][grade]
In the form i would pick one between [grade1] and [grade2] based on [key]
Is it possible and what would be the valid if condition?
I tried with Select but i’m not able to pick from 2 different column

thanks

Use a SELECT()+SELECT(). They both create return as lists and you can just add the lists together.

3 Likes

Thanks, it works
I didn’t try the “+”

2 Likes