To use or not to use Auto-Enter Calculation; that is the question.
I have a manufacturing database in which there are several calculation fields that, in special circumstances, a user may need to override the calculation result and instead enter a different value. Since calculation fields cannot be modified by a user, I thought the solution would be to change the calc field to an auto-enter calculation; thus, allowing the user to override the result when necessary.
Unfortunately, those auto-enter calculation fields are not evaluating. I am instead getting a "?" as a result. The calculations are painfully simple; e.g., "Quantity A/1000" or "Lbs Glue Ndd * Quantity A," etc. The fields evaluated fine when they were straight calc fields and I cannot figure out what a solution might be. I have a feeling my eyes are crazy crossed on this one.
I would love any guidance as to how I can accomplish my initial goal of allowing a user to override a calculation field - it seems I missed the mark with my thought of a straight Auto-Enter Calculation field.