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?
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
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..