I know how to make SQL lists from my ERP system in PDM. I can use this pulled data for pick lists. Great. Now, how can I pick a value in one list (say 3rd item down), and have the next list select the 3rd by default? I can't seem to figure out list controls.
Maybe you could make several different lists for your second selection -each one ordered a different way. Then depending on the choice of the first variable, you could use "Controlled by variable" to choose the desired ordered list?