I have the following requirement. I need to set the contents of a LIST BOX based on the selection from another LIST BOX

[#1]

I have the following requirement. I need to set the contentsof a LIST BOX based on the selection from another LIST BOX.

LIST BOX1  values Canada, USA /    LIST BOX2 values    Ontario, Quebec,  New York , Ohio

So when the LIST BOX1 has Canada selected, then LIST BOX2 should only display Ontario and Quebec and when
LIST BOX1 has USA selected the LIST BOX2 should only allow New York and Ohio.

Suggestions….

[alexandros17]

This is an automatic behaviour when data is properly linked, there must be a relationship between Canada and its regions, otherwise you must build this link on your own.

[jvishnuram]

Hi Marcus,

Try this out.,

SAMPLE:

LOAD * INLINE [

    Region, Country

    Canada, Ontario

    USA, Ohio

    USA, New York

    Canada, Quebec

];

if you are able to see my app, PFA.,

[MK_QSL]

Just create the list box Country using below expression

=Aggr(Country,Country)