4.0

Managing Database Records
Managing an OmniForm Database 185
For example, suppose you changed the mileage calculation in an
expense form to reflect the latest rate. All new records would use the
new calculation and reflect this rate. You do not want older records to
use the new calculation because the original rate was correct at the time.
If you recalculated all records after adding the new calculation to the
expense form, 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 179 for information on
searching.
You cannot recalculate records if data protection is turned on. See
“Protecting Your Database” on page 197 for information.
To recalculate records:
1 If you are in design view, click the Fill button in the design tool-
bar or choose
Fill
in the View menu to switch to fill view.
2 Choose
Recalculate...
in the Records menu.
The Recalculate dialog box appears.
3 Select the records to recalculate.
• Select
All Records
to apply the new or changed calculation to
either the current found set or to every record in the database
if the entire record set is open.
• Select
Current Record Only
to apply the new or changed calcu-
lation to just the record you are viewing.
• Select
From/To
to apply the new or changed calculation to a
range of records.
Enter a number in the
From
and
To
text boxes. If you entered
1 in the
From
text box and 5 in the
To
text box, for example,
OmniForm would recalculate the first five records in your da-
tabase or found set.