User manual

116 | Creating databases
Keep these points in mind:
1 A field that doesn’t appear on a layout still exists in the database, and its
data can be used in calculations and summaries.
1 To set the default formatting, appearance, and behavior of a field, choose
options with no fields selected. FileMaker Pro applies these defaults to all
fields added later. See
“Formatting field data on a layout” on page 121,
“Allowing or preventing entry into fields” on page 127, and Help. You can
also specify options individually for each field.
Note Options that are set in the Field/Control Setup dialog box cannot be defined
as defaults.
Placing and removing fields on a layout
You can place a field anywhere on any layout, as many times as you want. (You
can place only fields that you’ve defined. See
“Defining database fields” on
page 80.)
You get different results by placing the same field in different locations on the
layout. For example:
1 Add the same summary field to a subsummary part to calculate totals for
each group of sorted records, and to a grand summary part to get totals for
all the records in a table.
1 Add a field to the header or footer part to repeat data from the first record
or the last record on the page as a header or footer. (For example, add a Last
Name field to the header in a directory.)
1 Add the same related field directly on a layout to see the field’s value in the
first related record, or inside a portal to see values from more than one
related record. (A portal is a layout object that displays records from related
tables.)
To place a field on a layout:
1. In Layout mode, choose the layout you want to work on from the Layout
pop-up menu.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 116 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ