Hello, I'm sure this is simple to most of you, but could you please tell me the best way to do this:

I want to type one of three abbreviations (that I define) into a field, and have the second field automatically put in data according to which abbreviation I type in the first field.

For Example: Lets say I have Field A and Field B. In field A, I would enter abbreviations I have created, either xe, eps, or cc. If I entered "xe" in Field A, I want it to automatically enter $.80 in Field B. If I enter "eps" in Field A I want it to automatically enter $1.80 in Field B. If I enter "cc" in Field A I want it to automatically enter $.75 in Field B. And so on.... Thanks in advance for your help!

Edited December 5, 200520 yr by Guest

Case(

Field A = "xe"; "80";

Field A = "eps"; "1.80";

Field A = "cc"; ".75")

That worked perfectly, thank you very much!