Managing Database Records
Managing a Database 13
Recalculating Records
Recalculating records applies any new or changed calculations to
selected records in a database. Until you use the
Recalculate...
command,
new or changed calculations apply only to new records.
This command reapplies
all
existing calculations to the selected records.
You may not always want this to happen.
For example, suppose the mileage calculation in an expense form was
changed to reflect the latest rate. (The person who created the form in
the OmniForm program would make this change.)
All new records would use the new calculation and reflect this rate.
Older records would not reflect the new calculation because the original
rate was correct at the time.
If another new calculation was added to the same expense form and you
recalculated all records, the mileage rates on your old records would
also change. They would then be incorrect. To prevent this, you could
search the records for those records newer than the date that you
changed the mileage calculation, and apply the new calculation only to
the newer records.
See “Searching Records for Information” on page 4-7 for information on
searching.
You cannot recalculate records if data protection was turned on in the
form in the OmniForm program. Contact your OmniForm administrator
or the form’s creator if you need data protection turned off.
