- I have 3 tables related 1 to many records: A < B < C
- All 3 have a get(recordmodificationcount) field.
- Table B also has a calc field called 'mod_sum'= A + B + sum(C). A script is used to generate/ update records on a related table: B < D IF 'mod_sum' is > 'mod_sum_old' on Table B. 'mod_sum_old' has it's value set as 'mod_sum'+1 at the end of the script, so that they are =.
The above works. The problem comes when I export/ import records because there is always a difference between 'mod_sum' and 'mod_sum_old' when often there shouldn't be because there were no intended changes to records in A, B or C. All the above calc fields are unstored. I confess I've never used a stored calc field, but wonder
a) whether I should be storing the get(recordmodificationcount) values and
b) what it's properties are, ie. does it still 'get(recordmodificationcount)' when that count changes and what happens to the value when exported/imported?