FileMaker Pro 14: The Missing Manual

Chapter 2. Organizing and Editing Records

So far, you’ve learned how to use FileMaker’s basic tools and get around your database. But you’ve just begun to scratch the surface of FileMaker’s power. Now it’s time to learn how to see, sort, move, and shape your information in different ways. For example, you may want to print a list of names and addresses for all the folks in your database who live in the western U.S. In an invoicing database, you may want to find everybody who’s ordered 16-pound offset widgets in the last month so you can email them a special offer for widget accessories. In a student database, you may need to print a report of all third-grade students who were involved in lunchroom disciplinary actions during the first semester.

Whatever your needs, you can build on basic techniques to view your data in ever more sophisticated ways. After all, slicing, dicing, and analyzing your data is the whole point of storing the information in a database.

Views

In Chapter 1, you saw a few different ways you can view your data. Now it’s time to learn more about these views. The most common way to view and edit records is called Form view. In Form view, you work with just one record at a time. In List view, you see the same arrangement of your records in, well, a list. If the records don’t all fit in the window, you can use the vertical scroll bar to roll through them. Table view looks a lot like a spreadsheet, with one row for each record, and one column for each field.

To switch ...