Field value dependent on value list selection

[pmar]

I have a question that is difficult to explain. Essentially I want a field(A) to display one of two numbers. Each number is the value from two fields(B & C) entered on another layout. That would be easy enough but I want the decision of which number will be displayed to depend on another field(D). That field is a Pop-up Menu with 10 options, displayed as a value list. So, dependent on which option is selected in (D) one of two values will automatically be entered in (A). I think I need to define my database. But I can’t figure out how to write out the option for field(A). Should it be a calculation? It seems like I should be able to write a script that would automatically perform that function but can’t figure that out.

Could some one please help me with this?

[efen]

For field "a" you can hard code the values of "d" in an autoenter calculation, replacing existing value:

Case (

d = 1; c;

d = 2; b;

d = 3; c;

etc

)

[using the values of the "d" field instead of 1,2,3 above]