forcing a calculation update
Have a calculation that involves several related fields from another table. When
changing any of the related fields, the calculation will not update. However, if the
(key) Index value of the table with the calculation is re-entered, then the calculation
will update. (The calculation is inside a case statement where the case value is
not likely to change, but the parameters inside the case can often be changed.)
Is there any way to always get the calculation updated when one of its related
fields (from another table) is changed ? Thanks for your help.