Cascading prompts

[cogcurious]

If i have a cascading prompts scenario. Should the two prompts get the data from the same query or two different queries. Which is better?

[wyconian]

Hi

I think it's easier to have both prompts from the same query as the relationship between the items in the cascade are already there.

I think you can have 2 queries but you would need to have a filter in the second query to filter the results based on the value of the same prompt.

It's mucg easier to have just one

[blom0344]

Cascading prompts and prompt query filters do not mix well (resolve order trouble). Not using a cascade, but relying on a reprompt button offers the widest range of possibilities..