Hi. I have 2 dropdown menus on my form, Product Description & Product Code with the latter being dependent on the former. The user can select multiple product descriptions so I have set the type as Enum List, however when I select 2 products from the description drop down I am not presented with only 2 product codes in that dropdown. This works if both fields are of type Enum but not Enum List. Does it work with Enum List?
PDM_Business_Support (PDM Business Support) #1
Aleksi_Alkio (Aleksi Alkio) #2
You need to use SELECT expression like… SELECT(TableName[Product Code],IN([Product Description],[_THISROW].[Product]))
PDM_Business_Support (PDM Business Support) #3
Thank you Aleksi Translate
Aleksi_Alkio (Aleksi Alkio) #4