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
Chapter 2
Adding and viewing data
There are many ways to view and work with data in a FileMaker Pro
database. This chapter explains how to:
1 view records in a database
1 add, duplicate, and delete records
1 add and edit data in fields
1 work with text in fields
1 check the spelling of your data
For an introduction to fields and records, see “About fields and
records” on page 1-2.
About working with records in Browse mode
In Browse mode, you can enter, view, change, and delete data in your
database. FileMaker Pro saves the changes you make to your file as
you work.
In Browse mode, you can work with all the records in a file, or a
group of records (called the found set). You can display records in
sorted order or the order in which you added them to the file.
If you’re working in another mode, you can switch to Browse mode
by choosing View menu > Browse Mode.
Your database contains one or more layouts that display your data in
different ways. If your database has several layouts, you can choose
a different one from the layout pop-up menu at the top of the status
area.
For more information, see “Saving files” on page 1-7, “Finding
records” on page 3-1, “Sorting records” on page 3-8, and “About
layouts and reports” on page 6-1.
Layout
pop-up
menu
Book icon
Number of
records in
the file
Current sort
status of
records
Status area
Zoom controls
Status area control
Mode pop-up menu
Products file in Browse mode
Standard
toolbar