Skip to Content
0
Former Member
Feb 17, 2009 at 05:03 PM

Prompts Question

23 Views

I have a Prompt Question. I have a set of data. I want this prompt to be a static Prompt. The data looks like this. Its a list of states. For Example ( AR, OH, TN, TX, VA, AK, HI, NY, NJ, FL, IL, MO, MA)

I want the prompt to do the following. The table stores the State names in the State table. The list of values has to prompt the user for the following groups.

ALL

REGION 1

REGION 2

REGION 3

If the user selects ALL then the prompt has to query all the data for the above states listed

If the user selects REGION 1 then the prompt has to query for AR, OH, TN, TX, VA

If the user selects REGION 1 then the prompt has to query for TN, TX, VA, AK, HI, NY

If the user selects REGION 1 then the prompt has to query for TX, VA, AK, HI, NY, NJ, FL, IL, MO, MA

What is the easy way to do this. The default must be all,