AnsweredAssumed Answered

Look Up problem

Question asked by deepakgupta_1 on Apr 14, 2011
Latest reply on Apr 14, 2011 by philmodjunk


Look Up problem



I set up a calculation in a main table that uses data from another (look up values) table.  If I change the data in this values table. then the calculation results in the records already created (in the main table) change.  I am not able to 'unstore' the result in the main table as I the calculation is referencing a global field in the look up table (there isn't a relationship between the two tables (which would lead to the same problem anyway (I think))).

Is there a way round this problem, or am I going about it the wrong way?  I do not want the previous records to update.