Hi, 
I would like to Select a Variable from  a drop down menu that was previously pre-filtered to just specific output based on the name for example(IRD).

In my case I have a shape that has the following properties:

I have learned that I can generate a list of filtered items by creating a shape with properties:

It would be nice to combine these two.

NOT sure if I can specify one more shape data field option on SetVarOption: |Filter=  ?!

I have tried something like this:

or

Also I believe a possible solution could be using two list box controls but I don't have an example to adapt it to my case, meaning FKColumn must be different than SetColumn or DisplayColumn ? and on the filter side how do I reference to "OtherList" box."

Is there a way to sort this out ?

Thank you.

Regards,

Daniel.

"Linking two list box controls
It is possible to link two list boxes. That way, when you select an item in the first list box, you will filter the values displayed in the second list box.

In the second list box, use the SetVarOption "FKColumn" to define a foreign key relationship between the two datasets. In that option, specify the column in the second list box that contains the foreign keys that link to the first list box.

Example:

<em><code class="lang-txt">FKColumn=fkcolpid|Filter=[var:OtherList]
</code></em>

• In the "FKColumn" option, specify the parameter ID of the column that contains the foreign keys.
• In the "Filter" option, you can indicate that the list has to be filtered. In the example above, the list will be filtered by foreign key value, based on the value of the session variable that was set in the "OtherList" box."