I have a lookup combo box that gets a value from a table and another combo box that changes to the corresponding rate of the first combo box.
And I have a form field doing the calculation of the rate X quantitiy. But the number that the calculation field is using isn't the value in the first box, but the order of it - such as 0,1,2,3 etc.
How do I change it so that the first the contents of a combo box remains the value that one chooses, no t some private number?
Thanks!
And I have a form field doing the calculation of the rate X quantitiy. But the number that the calculation field is using isn't the value in the first box, but the order of it - such as 0,1,2,3 etc.
How do I change it so that the first the contents of a combo box remains the value that one chooses, no t some private number?
Thanks!
