User manual

6-16 FileMaker Pro User’s Guide
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 the database.
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. (For more information about setting up
a relational database and definitions of relational database
terminology, see chapter 8, “Working with related files.”)
Note If you are working with multiple related database files (a relational
database), you can display related fields on the layout. You can place
related fields directly on the layout or in a portal (a layout object that
displays data from all related records in the related file that match the
criteria of the relationship). Before you place a related field on your
layout, see “Deciding where to place related fields” on page 6-18 and
“Creating and formatting portals to hold related fields” on page 6-19.
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.
2. Drag a field from the Field tool to the position you want on the
layout.
As you drag the field onto the layout, you see a border and text
baselines to help you align the field with other objects on the layout.
Release the mouse button when the field is where you want it.
Note If you’re placing a related field in a portal, position it in the first
row of the portal. Make sure all the related fields use the same
relationship as the portal. (A related field that uses a different
relationship displays only one occurrence of the data.)
3. In the Specify Field dialog box, select the field to place.
To choose a related field, choose the relationship to use from the
relationship list above the list of fields. Or choose Define Relationships
to create a relationship (see “Defining relationships for relational
databases and lookups” on page 8-10). Then select a related field
from the field list.
4. Select Create field label to include the field name as text on the
layout.
5. Click OK.
You see the field name in the field on the layout unless you have
chosen to display sample data (View menu > Show > Sample Data).
To replace a field with another, in Layout mode, double-click the
field, then select another field name in the Specify Field dialog box
and click OK. If you created a field label when you placed the original
field, that text must be changed to reflect the new field name.
Field tool
The field’s border and
baselines appear as you drag
the fields onto the layout
Select the field to add
Select to use the field
name as the field label
To place a related field,
choose a relationship name,
then choose a related field