That is an enhancement request that I’d love to see implemented – it is not currently a built-in feature. Alternatively, you can take a look at Cascading Prompts.
Here’s a short writeup on cascading prompts in our Designer: FAQ.
Anita Craig 
(BOB member since 2002-06-17)