Can we set a variable or message for list boxes

[kkkumar82]

Hi all,

I have a list of three list boxes lets say for SalesmanID, ProductID, DistributorID and my requirement is one should be able to select only any of these listboxes, if a list box is already selected with a value we should not be able to select another listbox or can we get a on screen message saying a list box is already selected or can we set a flag with value 1 or 0.

Thanks

KK

[awhitfield]

Hi Kiran,

a simple way is to use a condition show on the layout tab of each of the three  boxes,

e.g

add this to the SalesManID object

If(GetFieldSelections(ProductID)>0,0,If(GetFieldSelections(DistributorID)>0,0,1))

I have attached a simple example qvw

Andy

[kkkumar82]

Hi Andrew,

Thanks for ur reply, the thing is I actually want to have all the list boxes shown but there should be only chance to select one list box only and if we try to select any other drop down a message should pop saying only one list box should be selected.

Thanks

KK

[awhitfield · Accepted solution]

HI Kiran, try the attached improved mark too version, you could make the Warning box conditional too!

Andy

[kkkumar82]

Hi Andrew,

Can you let me know how list boxes are disabled when we select a list box value.

Thanks

KK

[awhitfield]

Hi Kiran,

they are not actually disable, I've used a number of Semi Transparent Text box with a conditional show, which overlay part of the list boxes. if you user CTL+Shift+S to see the hidden text boxes!!

It's a bit of an optical illusion!

Andy

[kkkumar82]

Thanks Andrew its really a good idea of hide and show mechanism.

** kiran Kumar **

[awhitfield]

you liked it!

Andy