calculations using variable field values?

[gwjo]

I'm sure this is a silly question but I can't find the solution in the help index.....

I'm trying to set a value in a field based on a calculation involving the number of records in a related table but don't want the field to recalculate each time the number of records in the 2nd table changes. So, on day 1 there may be 100 records in the related table and I can record this and use it in my calculation. On day 2 there may be 120 records, and any new calculation will use this value, but I don't want the calcs done the previous day to change from the 100 record status. There must be a logical function to get the absolute value but I can't see it. I don't want to write a script for this using copy field and then paste - it seems too clumsy!

In frustration, many thanks,

George

[Tim W]

Not really sure I understand the structure of this problem. But, setfield will do the same as copy/paste, with more elegance. A calc with the "do not replace existing" will preserve yesterday's calc, given it fits into your data model. Or maybe a join table indexing each day's calc might be a solution.

HTH,

Tim