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?

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]