Does anyone know an easy way to create “dynamic” pick lists using single select?
In the example below I want the available “Analytical Method” options be dependent of the previous selections. For example, if there are 100 “Analytic Methods” available, but only 3 can be used for the “KF-Oven” activity, Product = “Other” and Material Lot = “Lot2” I only want the 3 to show, not all 100.
I know this is possible to some extent using tables, but have not found a way to achieve this using single select.
Any feedback on this topic will be greatly appreciated!