I have an input box that has the following variables:-
Range 1 = 0
Range 2 = 500
Range 3 = 501
Range 4 = 1000
Range 5 =1001
Range 6 =1500
Range 7 =1501
Range 8 =2000
Range 9 =2001
Range 10 =3000
I'd like to have a list box that is populated with the above variables as follows when the user enters the ranges in the input box
Range 1 - Range 2
Range 3 - Range 4
Range 5 - Range 6
Range 7 - Range 8
Range 9 - Range 10
I'd also like to select from the dynamically populated list box and i want it to reflect on a 2nd list box called Salary.
Load * Inline
So, if for example, the user enters Range 1 = 0, Range 2 = 500 and i select that, then only 300 and 500 would show up in the salary list box. is this doable? I tried using the Class function, but it has a fixed width, what i want to do is allow the user to specify the width for each line in the Ranges list box.
Any help is much appreciated.
As you started like - 'I have an input box that has the following variables' . Did you mean like this -
Can you elaborate how you are selecting multiple ranges in the beginning? Can you select like 0 to 1500 , and if yes then how?
Thanks so much for the reply
This looks great! but would it be possible in the Range Listbox to have the value of the ranges written instead of the words Range1, Range2, etc...
Also, could you please add the functionality for the rest of the ranges in the expression in the salary listbox? I tried, but there is an error.
I'm sorry, but i'm still a beginner.
yes, that's pretty much it.
we'd like the user to populate the selections in the ranges list box, so basically, he can write 0 in the vRange1 and 1500 in vRange2, which will result in having the first row = 0 - 1500, and he can select that and it will reflect on Salaries listbox.
Please don't hesitate if you'd like me to explain more.
Thanks for the reply,
This is a great idea, except the width is not always fixed, which is why i'm putting 10 variables so that the user can have his custom list of ranges like the following
200 - 800
1000 - 1500
1800 - 1900
2000 - 2700
3100 - 3200
as you can see, with this, salaries with 900 will never appear because there is no selection that includes 900, same goes for 1600,1700. tresesco up above is on the right track.