How to subset based on multiple combo box selections
Apr 25, 2016 7:30 AM(4226 views)
I'm trying to write a script that creates a subset based on two choices in a dynamic combo box. It seems like the dialog portion is good since my variables are being saved as I select them, but the actual generation of the subset is not working.
In this example, both myFilm and myTool will be strings. As the Select Where is written, if :Film or :Tool are numeric columns, then no rows will be selected because it is not possible for a numeric column to have a string value. The Num() function will convert a number represented as a string (for example, "12") to a numeric value.
Another thing to consider is that it might be possible for there to be no matching values in the data for the selections made in your New Window. The user is presented with all the unique values of :Film and the unique values of :Tool, but that does not mean that for every value of :Film every value of :Tool is represented in the data. The Select Where() statement is only selecting rows where both conditions are true.