User manual

92 | Creating databases
Setting options for fields
You can set field options when you define a field, or at a later time. You can set
options for:
1 entering default data into a field
1 checking data against validation requirements
1 making a repeating field
1 creating an index
1 storing a global value
1 Furigana fields (Japanese language fields only)
Some field options help ensure the accuracy and consistency of your data. For
example, if you type Frnc instead of France into the Country field, you won’t
find that record when you later search for all customers from France. To be sure
that all country names are entered correctly, you can define a value list
containing the names, then select the Member of value list validation option for
the Country field. When you enter data into the field, the data must match a
value in the list.
For more information on value lists, see “Setting up checkbox sets and other
controls on a layout” on page 118.
To set options for summary fields, see “Defining summary fields” on page 88.
Defining automatic data entry
To automatically enter a default value into a field for each record:
1. With the database open, choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Fields tab.
3. If your file contains more than one table, select the appropriate table from
the Table list.
4. Double-click a field in the fields list.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 92 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ