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
Adding and viewing data
2-3
2. If FileMaker Pro prompts you to save your changes to the layout,
you can choose how the layout is displayed the next time you open
the file.
Keep these points in mind:
1 If you have layout design privileges, you can set options to
customize the way a layout displays and functions in View as Table.
(See“Setting up View as Form, View as List, and View as Table” on
page 6-10.)
1 You can select multiple columns to reorder, resize, or sort data, but
you can’t select multiple cells in a table.
1 If a layout contains a portal, View as Table displays the data from
the first related record (the first row of the portal). See “About
relational databases” on page 8-2.
1 For more information about View as Table, choose Help menu >
Contents and Index, click the Index tab, and type View as Table
command.
Selecting the current record
In Browse mode, a database has one current (selected) record at a
time.
For information about views, see “Viewing records” on page 2-2.
To select a related record in a portal, select the portal row (click
inside the row but outside any fields in the row). For information
about related records and portals, see “About relational databases”
on page 8-2.
To Click
See your layout changes Yes
See the layout as it looked before your changes No
Current record
bar indicates the
selected record
View as Table
Column headings. Each column displays
one field from the current layout
Values in a repeating
field display horizontally
In this view The current record is
View as Form The record that you’re displaying.
View as List
or
View as Table
The record that’s marked with a solid bar along the
left side. To work with another record, click in the
record to make it current.
Current
record bar in
View as List