Forum Discussion
RobbSalzmann
2 years agoValued Contributor II
Sounds similar to a combo-edits type requirement. The choice in the first combobox drives what choices are available in the next combobox and so on.
One way to do this is make your parameters sql lookups.
Lets say you have three things that sequentially rely on the choice in the prior:
The where clause in the second parameter uses the value of the first parameter:
Select SecondParamValue as values from ValueTable where FirstParamValue = |!pm_FirstParam!|
The where clause in the third parameter uses the value of |!pm_FirstParam!| and |!pm_SecpondParam!|:
Select ThirdParamValue as values from ValueTable where FirstParamValue = |!pm_FirstParam!| and SecondParamValue = |!pm_SecondParam!|
Related Content
- 11 months ago