Listbox problem

[AH]

Hi,

Lets say I have a listbox and its showing values like this:

Country

USA

UK

UAE

KSA

ITA

Now i would like to make the listbox behave like this way:

I would like to show only 'USA' value in the country list Box. But when the 'USA' value is not checked/Selected then It will show the values corresponding other countries to other fields by association. But when 'USA' value is checked then Country field shows the 'USA' value is selected and values corresponding to 'USA' to other fields shows by association.

Thanks & regards

[Lisa_P]

On the General tab of the List box properties, you can tick the Hide Excluded option to only show the selected or associated/possible values.

[Anonymous · Accepted solution]

Hi,

write below expression in field <expression of list box>

=if(Country]='USA',[Customer Country])

[sudhirpkuwar]

Hi,

Can you give the expected output...

[AH]

Thanks a Lot Aruna!

Regards,