Hi guys, I have a problem with creating a dropdown or a list filtered considering multi values.
My app is for quick search equipment can match with compatibles accessories.
I have 2 main dataset:
EQtab where I record all equipment
ACCtab where I record all accessories
All records in both tables has 3 column type YES/NO indicating the compatibility category:
[Cat1], [Cat2], [Cat3].
So I’m creating a table called SEEK to record all research for each user.
This tables has [IDcolumn], [UserID] type ref, [EQ_ID] type ref with Valid_if constrict dropdown and [ACC_ID] type ref .
The goal would be to obtain a compatibility list based on the selected equipment:
“EQ_1” has [Cat1] and [Cat3] set on TRUE and [Cat2] set on FALSE
“AC_1” has [Cat1] set on TRUE and [Cat2], [Cat3] set on FALSE
“AC_2” has [Cat2] set on TRUE and [Cat1], [Cat3] set on FALSE
AC_3 has [Cat2], [Cat3] set on TRUE and [Cat1] set on FALSE
In this example when i search for EQ_1’s compatibles accessory the list of selection should includes only AC_1 and AC_3.
I tried several expression but with no right result…
Hope some one could help for fixing.