Selection Logic

[vanderson009]

Hi guys,

I have 2 listbox. As listbox1 and listbox2.

listbox1 having values like a,b,c and listbox1 having values like 1,2, 3 respectivaly

If i click on "a" then want output in text box as like 1

If i click on "b" then want output in text box as like 2

If i click on "c" then want output in text box as like 3

Thanks in advance

--Regards,

Villyee

[Anonymous]

try with this expression in your text box:

=if(only(abcField)='a', 1, if(only(abcField)='b', 2, if(only(abcField)='c', 3)))

abcField is the name of the field used in your listbox1.

Marc.

[sunny_talwar]

May be like this? PFA

Best,

S

[#4]

List box will work with data association, so if that's the relationship between  Field 1 and Field 2 then it will populate that.