How to make a Conditional Listbox?

djhanson

Hi, how to make one listbox depend on the entry of another preceding it? Example, if I choose Country="US" in first listbox, how to make the second listbox only display US states? Also, if one chooses to reselect to Country="Canada", can I somehow make the second listbox refresh with the Canadian provinces?

Country = {US, Canada, Mexico};
USSub = {Alaska, Arizona, California};
CanadaSub = {British Columbia, Alberta, Saskatchewan};
MexicoSub = {Baha North, Baha South, Sonora};

If(Country=="US",Sub=USSub,Country=="Canada",Sub=CanadaSub,Country=="Mexico",Sub=MexicoSub);

TextBox("Country:"),
name_box1 = ListBox(Country),
choiceCountry = name_box1 << get selected,
TextBox("State-Province:"),
name_box2 = ListBox(Sub),
choiceSub = name_box2 << get selected,


Message was edited by: djhanson

Message was edited by: djhanson

ms

As djhannson notes, you must include the refresh code in the name_box1 script. In your script each interaction with name_box1 will complete with <<remove all and hence the second list box will always be empty.

Here is one way to do it that works in JMP 9.

Country = {US, Canada, Mexico};

USSub = {Alaska, Arizona, California};

CanadaSub = {British Columbia, Alberta, Saskatchewan};

MexicoSub = {Baha North, Baha South, Sonora};

aa = Associative Array( Country, {UsSub, CanadaSub, mexicoSub} );

New Window( "jkahd",

  Text Box( "Country:" ),

          name_box1 = List Box(Country,

                    name_box2 << remove all;

                    name_box2 << append(

                              Eval( aa[Parse( (name_box1 << get selected)[1] )] )

                    ); // Parse() not needed if original lists had quoted strings e.g. {"US",...}

          ),

  Text Box( "State-Province:" ),

          name_box2 = List Box( {} )

);