One prompt values based on another prompt
858625Dec 15 2011 — edited Dec 16 2011Hello All,
Here is the situation. I have two prompts. The second prompt values are based on a SQL. The requirement is to filter the values of the second prompt based on what is selected on the first prompt. I have read the other threads on this issue. One possible way is to make use of the presentation variable. But the second prompt would get filtered only when I hit the go button on the first prompt.
Is there any way I can update the second prompt just by selecting a value from the first prompt and not hitting the go button?
I mean can I have both the prompts in the same section and have the second prompt update itself based on the first prompt.
Thank you very much.