Highlighted

Drop-Down List Value Referencing

Avatar

Guest

06-06-2008

Total newbie to FormCalc so I really need some help as I can't seem to figure this out.



I'm working with drop-down lists and I've set the bound data value of each item as a name of another field in my form. These referenced fields are numerical fields and all I want to do is when I select something from the drop down list, I want it to pull the data value from the field references in the bound data and place it in another numerical field.



Example from list: You select "Dodge" from the drop down list (field name "Skill." The value given this item is "Agi." There is a field of "Agi" that would hold a value, say "3." There's a third field called "SkillAdj." So what should happen when you select "Dodge" is that it will pull the value of "3" from the "Agi" field and display it in the "SkillAdj" field. How would I code this because I can't seem to reference the data at all.



Thanks in advance and I hope I explained myself clearly.