Hi. I have 2 dropdown menus on my form, Produ...

(PDM Business Support) #1

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?

(Aleksi Alkio) #2

You need to use SELECT expression like… SELECT(TableName[Product Code],IN([Product Description],[_THISROW].[Product]))

(PDM Business Support) #3

Thank you Aleksi Translate

(Aleksi Alkio) #4

You’re welcome