Multiselect with cascading prompt

[Shailaja0520]

i have a source prompt as value prompt and a child prompt cascaded from the source.
Multiselect is Yes in both the prompts.


suppose
in source prompt i have values(not static choices)
1,2
Child prompt is associated with a value-Case condition
if 1 the 1
if 2 then 2

so when i select 1 in source prompt it gives 1 in child prompt
and for 2 it gives 2.

but if i select both it gives only single value in the child prompt.
Can anyone suggest for this

[MFGF]

Hi,

The problem is with your if-then-else in the second prompt.  Once an if-then-else finds a single True result, it stops processing.  Can you use a Query to drive your second prompt instead?

MF.

[shrini]

Hi MF,

Can you eloborate it so that we can get a clear pic onit

Thanks,
Shrini

[MFGF]

Sure - define a query which retrieves the values to display in your second prompt, then use this query in the prompt by specifying it in the prompt's "Query" property.

MF.