AnsweredAssumed Answered

forcing a calculation update

Question asked by CountryBoy1 on Feb 11, 2009
Latest reply on Feb 11, 2009 by raybaudi


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.