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,