User manual

80 | Creating databases
Defining database fields
To define a new field, you give it a name and select a field type. Then you select
options that determine how the field interprets, enters, calculates, stores, and
displays data. These characteristics make up the field definition. See
“Setting
options for fields” on page 92 for information on setting these options.
See “Formatting field data on a layout” on page 121 for information about
setting options for field formats, which control how data appears on a layout.
The following sections describe how to define fields using the Fields tab in the
Manage Database dialog box.
This field stores only numbers
This field calculates a value based on
another value in the record
(“Discount” is 10% of “Unit Price”)
This field stores multiple values
ET14Product ID
Jacket Product Name
ClothingCategory
BlueColors
$52.50Unit Price
$5.25Discount
Black
These fields store text
Field names
and definitions
Type a name for a
new field
Select a
field type
Click after you type a field
name and select a field type
Choose the way fields are listed in the dialog box
Click to sort by
field name or type
φμπ10_υσερσ_γυιδε.βοοκ Παγε 80 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ