Cascading Prompt?

[MK_USF]

I have a "yes"/"no" prompt. If the answer is "yes" then force an additional prompt. It is the response to this additional prompt that I want to select/filter on. If its "no" then just do the reset of the select formula.

Do I use a cascading prompt?

My logic (sorry if this is confusing):
If {?YNPrompt} = "yes" then {?NamePrompt} else false? <-- this has to be boolean correct?

How is this written into the select formula?

Thank you in advance

 

[Charliy]

You don't need to use cascading for that.

(isnull({?NamePrompt}) or {table.name} = {?NamePrompt})

you could also use
({?NamePrompt = "ALL" OR {table.name} = {?NamePrompt})