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
2-4
FileMaker Pro User’s Guide
Moving through records
To move from one record to another, use the book icon in the status
area.
Adding and duplicating records
When you add or duplicate records, FileMaker Pro stores new
records at the end of the file. In Browse mode, you see the new record
after the current record, or after the last record in the found set:
1 If records are sorted or semi-sorted, the new record appears
immediately after the current record, and the sort status changes to
Semi-sorted.
1 If records are unsorted, the new record appears after the last record
in the found set. For more information, see “Sorting records” on
page 3-8.
Note If a file is locked or write-protected, or you don’t have access
privileges to create records, FileMaker Pro doesn’t add new records.
See “Defining passwords” on page 9-1.
To move Do this
One record at a time
forward
Click the bottom page of the book icon.
One record at a time
backward
Click the top page of the book icon.
Quickly to a specific
record
1 Click the current record number at the bottom of the
book icon, type the record number you want, then
press Enter (Windows) or Return (Mac OS).
1 Press Esc, type the record number, then press Enter
or Return.
Click inside the portal row
to select a related record
Portal
Book icon
Bookmark
Current record number
Number of records
in the database
Quickly through
records
Drag the bookmark down or up to move forward or
backward.
Through records in
View as List or View as
Table
Use the scroll bar on the right side of the window.
To a record with a
unique value that you
know
See “Finding records” on page 3-1.
To Do this in Browse mode
Add a new blank record Choose Records menu > New Record. You see a
blank record with one field selected.
Quickly add a record
with the same or similar
data as an existing record
Select the record to duplicate. Then, choose Records
menu > Duplicate Record. (See “Selecting the current
record” on page 2-3.)
Add or duplicate related
records
See the next section.
To move Do this