Calculation with variable

[jesperv]

I

[dspires]

Make 'M2' an unstored calculation field instead of a field set by a script. To further aid in a more robust solution, consider setting the 'Scale" field to a single number. On the layout have "Scale: 1:" displayed next to the input field.

[jesperv]

I would like not to change the "Scale" field.

Is it possible to use the "If" command in a calculation field?

[jesperv]

Them ******* trees is hiding the forrest.

A lookup field was the answer.

[Chuck]

You can make M2 a calculation number field set to the following:

Case(

[jesperv]

Great, Thank you.