Database Reference
In-Depth Information
Figure 4-1. The Manage Database window is the most efficient way to create and manage fields.
You can also Duplicate or Delete fields here. Rename a field by selecting it from the list, typing the
new name and then clicking the Change button.
1.
Choose File
→
Manage
→
Database and then click the Fields tab (if it isn't already
active)
.
The Fields tab is where most of your field creation takes place. (See the box on
Use
the Keyboard
for more information about using this window.)
2.
In the Field Name field, type
Lease Value
.
As with other database elements, it's best to use simple, descriptive names for your
new calculation field.
3.
From the Type pop-up menu, choose Calculation and then click Create
.
The Specify Calculation window appears. Here's where you'll write the formula that
gives you the Lease Value. It's based on data in the Lease Duration and Rental Fee
fields.
4.
In the Current Table list, double-click the Lease Duration field
.
