multiple linked drop downs in prompt page

[bnruser]

Hi,

I have the following requirement in designing a prompt page for a report in reportnet. I should have four drop down controls in the prompt page as below,

Area  - Dropdown box 1
Region â€" Dropdown box 2
Country â€" Dropdown box 3
City - Dropdown box 4

Where area is the top most item in the hierarchy, which means that ‘Area’ has many ‘Regions’ under it and ‘Region’ has many ‘Countries’ under it and the flow goes so on.

Now I have to design the prompt page in such a way that when I select a particular ‘Area’, I should populate the other drop downs with appropriate values, which falls under that specific ‘Area’ and if I change the selection for ‘Area’, the populated fields for the other dropdowns should change dynamically and this kind of behavior is expected from all the drop downs. I am in the learning phase and if some one can give me a good idea of how once can design such a screen, it would be of much help.

Thanks
raj

[COGNOiSe administrator]

Cascading prompts should work for you fine. If you'd prefer "smooth-dynamic" response, you would have to deal with some JavaScript.