Cascading Prompts

Just learned an interesting thing based on documentation on http://www.tek-tips.com/viewthread.cfm?qid=1342510&page=58

When building cascading prompts be sure to understand the mechanism that will cause the cascade to go through. One is for the second cascade which is based on the previous one to mention that in the definition of the prompt. Secondly, if there is only one seletion from the first prompt we could just use the auto-submit other wise if the first prompt has more than one prompts that can be selected then we need to use the "prompt button" which is in the insertable objects panel (last one actually). Once you drop it in (preferably below the first multi select prompt column) you can rename it by dropping a text on top of it. Fascinating :-)