User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
6-10
FileMaker Pro User’s Guide
Note Use merge fields or fields or objects with sliding enabled to fit
more data into the width of a column. With either of these two
features, fields can extend into the gray area of the second column,
and blank space in fields is eliminated when you view or print data.
See “Placing merge fields” on page 6-17 and “About removing blank
space from printed data” on page 7-22.
If you change the number of columns, FileMaker Pro adjusts the
width of the columns to fit within the width of the paper size you
have defined, not including fixed margins. You may need to readjust
fields to fit within the sample column.
Keep these points in mind:
1 When you select Down first, FileMaker Pro prints subsummary parts
the width of the column. If you’ve specified that a page break comes
after the subsummary part, FileMaker Pro starts a new column (not a
new page). With Across first, subsummary parts print the width of the
page, and the specified page break starts a new page. (See “Defining
page breaks and numbering” on page 6-29.)
1 For information about other options in the Layout Setup dialog
box, see the next section and “Specifying page margins” on
page 7-21.
Setting up View as Form, View as List, and View as Table
FileMaker Pro provides three different views of each layout: form,
list, and table. When you change views, you change the way records
display or print. For more information about the differences between
views and how to use them, see “Viewing records” on page 2-2.
In Layout mode, you can specify which views are available in other
modes.
1. Choose the layout you want to work with from the layout pop-up
menu.
2. Choose Layouts menu > Layout Setup.
3. In the Layout Setup dialog box, click the Views tab, then select one
or more views.
Unless you change the default settings, FileMaker Pro enables all
views.
4. Select Table View to see the Table View Properties dialog box.
For more complete information about table view properties, see the
FileMaker Pro onscreen Help. Choose Help menu > Contents and
Index, click the Index tab, and type View as Table command.
5. Click OK.
When
you select
This menu command is enabled
in Browse and Find modes
Form View View menu > View as Form
List View View menu > View as List
Table View View menu > View as Table
Specify table grid settings
Specify whether FileMaker Pro
displays the header or footer part
Specify whether FileMaker Pro
displays column headers and
how they behave
Specify a custom row height
(all rows are the same height)