Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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….
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.
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.,
Just create the list box Country using below expression
=Aggr(Country,Country)