Prevent calculation from recalculating
How do you prevent a calculation from recalculating? I have a calculation field that is based on 2 fields on the same table. If I change one of those fields, I don't want the calc field to alter at all.
Under Storage Options I have "Do not store calculation results -- recalculate when needed" unchecked, so it shouldn't recalculate when one of the 2 fields are changed. The idea behind this is the calc field is a primary key and I don't want the primary key/ID number to change ever, but the Company name may change over it's life which is what the primary key calc field is based on.