User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
Creating databases 49
Important FileMaker Pro considers the selected printer, and print or
page setup information when it calculates margins and other
measurements on the layout. Printer and print settings depend on the
printer and system software you’re using. Refer to your printer and
system documentation for more information
.
Note You must create the fields to include on a layout before you
begin the New Layout/Report assistant. See
“Defining database
fields” on page 39.
To create a layout:
1. Choose View menu > Layout Mode.
2. If you intend to print the new layout in landscape orientation or on
a special paper size, choose File menu > Print Setup (Windows) or File
menu >
Page Setup (Mac OS), confirm the orientation and paper
settings, then click
OK.
Modified Print Setup and Page Setup settings affect all other layouts
in the current file, so you may need to change these settings later to
print other layouts properly.
3. Choose Layouts menu > New Layout/Report.
You see the New Layout/Report assistant, a series of panels, that
assist you with creating the type of layout you choose in the first
panel.
4. If the file has multiple tables, select the table from which you want
records displayed in this layout and give the layout a name.
5. Follow the onscreen instructions to create the type of layout you
chose in the first panel.
For a description of each of the layout types you can create with the
assistant, see the next section,
“About layout types.”
6. When you have completed the series of panels, click Finish.
You can use the new layout right away, or further customize it using
the tools and commands in Layout mode. For more information, see
“Working with objects on a layout” on page 52 and “Working with
fields on a layout” on page 54.
About layout types
The following sections describe each of the layouts that you can
create with the New Layout/Report assistant.
Standard form
A Standard form layout is a good choice for data entry or onscreen
browsing. It contains the fields you select, each on a separate line, in
the order you specify, with field labels to the left of the fields. In
Browse mode, you see one record, or form
, at a time (unless you have
switched from
View as Form).
Columnar list/report
Use a Columnar list/report layout when you want to view or print
multiple records in rows (a list of records). You can define many
variations of a
Columnar list/report with the New Layout/Report
assistant. You can create a layout with simple rows and columns of
data or a complex report with data grouped by specified values with
subtotals and grand totals.
A Columnar list/report layout contains the fields you select, in the
order you specify from left to right across the page, with field names
as column headings.
Field labels
Fields you defined, in the order they appear in
the Define Database dialog box