Dynamically changing default selection of one prompt based on another. Without Limit By

User_28Q0J

Is there a way to control the default selection of a prompt based on another prompt, when there is no relationship between them

Example; Prompt A (single select) has values - Yes (default), No

Prompt B (Multi Select) has Values - (All Column Values), 1, 2, 3

When Prompt A is selected as Yes, then Prompt B's default selection should be 1 and 3

When Prompt A is selected as No, then Prompt B should check (All Column Values).

I tried using SQL results but the prompt B default values are not refreshing back from 1 and 3 to (All Column Values)

Thanks

User_28Q0J

Have any one come across such scenarios?