Tutorial
Table Of Contents
- Contents
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Use quick find to search a database
- Find records based on criteria in a single field
- Find records based on criteria in specific separate fields
- Find records that match multiple criteria in the same field
- Find records that match a range of criteria in the same field
- Narrow your search
- Save a find request to use later
- Find records using a Saved Find
- Sort your found set
- Add a new record in List View
- For more information
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Charting data
- Lesson 11 Making databases relational
- Lesson 12 Sharing and exchanging data
- Lesson 13 Protecting data in FileMaker Pro
- Lesson 14 Backing up your databases
62 FileMaker Pro Tutorial
2. In the Modify Table View dialog box, clear the checkboxes for all fields except Company, First Name,
Last Name, and Fee Paid.
Columns are hidden in Table View as you clear checkboxes.
3. Click OK.
Group and sort data and define a summary field
1. Right-click the Company column heading and choose Add Trailing Group by Company in the shortcut
menu.
Notice that records are reordered and grouped by company. When you add a leading or trailing group in
Table View, FileMaker
Pro automatically sorts records in alphabetical order (a-z) by the group field.
Fields you group by are referred to as break fields. In this case, the Company field is the break field.
2. Right-click the Fee Paid column heading, choose Trailing Subtotals, then Total (Membership Revenue) in
the shortcut menu.
Subtotal amounts appear in the Fee Paid column at each company grouping.
Note If you can’t see the subtotal amounts in the Fee Paid column, drag the Fee Paid column heading to
make the column wider.
Clear the checkboxes of
fields you want to hide in
Table View