Ouch… ok I’m sorry about it, in the meanwhile I forwarded this to a “pro” but the answer has been INTERSECT is not the right expression to use. Strange and I’m not convinct… I will wait and maybe someone else could help me to understand how do it or ...

Steve: INTERSECT([ENUMLIST ID_A], [ID_B].[ENUMLIST]) It’s not working, of course I wasn’t clear. Please have a look at these: [TAB_A] is ref and is dropdown (no Valid If constrict required) [TAB_B] is ref but require a INTERSECT expression in Valid I...

Hi Steve, yes TAB_A , TAB_B , TAB_C are tables, [ID_A] is the key column of the rows in TAB_A. All rows in TAB_A and TAB_B have a column [Match] of different combine of values : “a”, “b”, “c” In the TAB_C I need to have 2 referenced column (type Enum...

Please would you link a complete example how is possible to obtain an list of value referenced in a TAB using INTERSECT function for filtering value from others 2 TABs? I try to explain better… TAB_A : each row is referenced by [ID_A] and has a colum...