Create listbox based on concatenation of string & value selected in another listbox

[#1]

Hello,

I have a listbox titled Category with with values B and M. In my data I have 4 columns B_Country, B_Region, M_Country, M_Region.

I want to create a dynamic listbox which will show countries belonging to B_Country for B_Region = 'EU' when B is selected in listbox titled Category.The same logic applies when I select M.

I created a listbox and defined the rule in field expression as: =If('$(=Category)'&'_Region' = 'EU', '$(=Category)'&'_Country')

But it's not working.

Can you please help me in resolving this?

Regards,

Ayandeep

[Anonymous]

Ah ok no problem.

I use this following expression:

=If( GetFieldSelections([Booked Region])='Europe' or GetFieldSelections(Category)='Booked',Category&'_'&[Booked Country]

,If( GetFieldSelections([Managed Region])='Europe' or GetFieldSelections(Category)='Managed',Category&'_'&[Managed Country] ))

[#3]

Assign your expression to one variable and re use the variable in listbox by using expression option