Setting the export Value of a drop down menu to the value of another field
As the subject implies, I'm trying to make the Export Values of 3 items in a drop down menu, equal one of 3 text boxes.
Item1, Item2, and Item3 in the drop down should all have Export Values equal to the value of Text1, Text2 and Text3 respectively. All 3 texts can be changed, so I can't set the Export Values statically. Depending on your drop down choice that value then gets put into Text4 box for calculations.
e.g. Text1 = 5, Text2 = 3, and Text3 = 6.
If you choose Item2, the calulation in Text4 should be (Item2+10) which would show 13 in this example. If you then change the drop down to Item3, Text4 would show 16. If you change Text3 to 2, Text4 would show to 12.
Any help on this conundrum would help greatly!
