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
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.
Hi MF,
Can you eloborate it so that we can get a clear pic onit
Thanks,
Shrini
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.