Hello,
If I have two columns in a file, I can create a combo box using the two columns separately (see JSL file attached). However, what I really want is that once I select the first option (say "a"), it should restrict my second box options to "a1", "a2" and "a3" only. See the Excel file attached.
Any help would be appreciated.
v1="m";
v2="n";
dt = Open("JMP_Question.xlsx",Worksheets("Sheet1"),invisible);
subDt1 = dt << Subset (Columns (:Column 1),invisible); summarize(col1_unique_vals=by(Column 1));
subDt2 = dt << Subset (Columns (:Column 2),invisible); summarize(col2_unique_vals=by(Column 2));
win = New Window( "Set the Value",
H List Box( Text Box( "Col1" ), combo_box1 = Combo Box( col1_unique_vals )),
H List Box( Text Box( "Col2" ), combo_box2 = Combo Box( col2_unique_vals )),
H List Box(
Button Box( "OK",
v1 = combo_box1 << get selected;
v2 = combo_box2 << get selected;
win << close window;
),
//a cancel button that closes the window and doesn't store store the results
Button Box( "Cancel", win << close window )
)
);
JMP Version - JMP Pro 14
