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?
You need to use SELECT expression likeโฆ SELECT(TableName[Product Code],IN([Product Description],[_THISROW].[Product]))
Thank you Aleksi Translate
Youโre welcome
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |