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

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?

0 3 318
3 REPLIES 3

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

Thank you Aleksi Translate

Youโ€™re welcome

Top Labels in this Space