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.