How to display the values in the list base on other list box vales?

[#1]

Hello All,

How to display the values in the list base on other list box vales

Let Say I have tow list box with same vales as below,

ListBox1	ListBox2
Region	Region
Country	Country
Partner	Partner

if I select 'Region' in the ListBox1 in the ListBox2, it must show only 'Country' and 'Partner'.

Kindly help.

Thanks & Regards,

MVV Satish.

[datanibbler]

Hi Satish,

I don't quite understand what these listboxes are supposed to be - are they multi_selection boxes where you can select a region, a country and a partner?

If that were so, you would just have to set the second multi_selection box (for essentially the same fields, yes?) to show only the selectable items - you could also try using the GETFIELDSELECTION() function to control the visibility of the individual fields in the second multi_selection box.

HTH

Best regards,

DataNibbler

[#3]

Hi,

Your action (button, text, ...) must be:

1) Select in Field / REGION (the name of your dimension)

2) The search string :

  = replace( '(' & concat({1-$} DISTINCT REGION, '|') &')', ' ', '?')

Fabrice