User manual

46 FileMaker Pro User’s Guide
7. To define options for the field, click Options.
For more information about field options, see Help.
8. Continue to define fields, or click OK.
Defining calculation fields
1. With the database open, choose File menu > Define > Database.
2. In the Define 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. For Field Name, type a name for the field.
See “About naming fields” on page 44.
5. For Type, select Calculation.
You can enter a description of the field in the Comment box.
6. Click Create.
You see the Specify Calculation dialog box.
7. If necessary, for Evaluate this calculation from the context of, choose
a table from the list.
Setting the context for a calculation is only necessary when you’re
creating a calculation field in a
source table that has two or more
occurrences in the relationships graph. The source table is the table
defined in the
Tables tab of the Define Database dialog box. The
choice you make may affect the calculation results, particularly if your
calculation will include fields in related tables.
To Do this in the Options for Field dialog box
Automatically enter
values into the field
Click the Auto-Enter tab, select the options, then click
OK. See “Defining automatic data entry” on page 50.
Make sure data is entered
into the field correctly
Click the Validation tab, select the options, then click
OK. See “Defining field validation” on page 50.
Important To avoid confusion when using dates in
FileMaker Pro, set field validation options to make
sure dates are always entered with four-digit years.
Make the field repeating Click the Storage tab, then select Maximum number of
repetitions. Type the number of repetitions (up to
1000), then click OK. For more information, see Help.
Select options for
indexing the field
Click the Storage tab, select the options, then click OK.
Make the field use one
value for all records in
the file
Click the Storage tab, select Use global storage, then
click OK.
Create a link between the
“parent” data field and
the Furigana “child”
field, so that when you
input Kanji characters
into the “parent” field,
the corresponding Kana
reading appears in the
Furigana “child” field.
Click the Furigana tab, select Use Furigana Field, the
Furigana field, and the Kana reading input format,
then click OK.
Note This option is available if your operating
system is configured to support Japanese text entry.
Available for text fields only.