Good Morning,
A little confused,
I have a Table with 3 Columns.
Column A: Type Ref
Column B: Type EnumList Base is Ref
Column C: Type EnumList Base is Ref
Wanted Behaviour:
User Select Column A,
Based on Selection is Column A, Populate Column B.
Based on Selections from Column B Populate Column C
User Chooses Item/'s from Column C
This is what I have.
Column B has a Valid if from Column A.
Expression
Select(ColumnBRefTable[ID], [Column in Ref] = [_Thisrow].[Column A])
This is Working,
My Problem is trying to get a Valid if Select Expression for column C Based on Selected Values in Column B.
Expression:
Select(ColumnCRefTable[ID], [Column in Ref] = [_ThisRow].[Column B])
Column C Valid if expression is Telling me
Cannot compare List with Ref
How would one Typically go about this?
LinkedIn
Twitter
