Records in FileMaker

In Chapter 3, “Exploring FileMaker Pro,” you became familiar with the FileMaker Pro application environment. You learned about the commands that FileMaker Pro provides and the various ways that you can access them.

In this chapter, you use what you learned to explore and work with the database you created. You change, add, and delete records; navigate through records and layouts; and much more. This chapter provides you a more thorough understanding of how to use a FileMaker Pro database.


Changing an Existing Record

When you created the Contacts database, FileMaker Pro automatically added the first record for you. With the exception of the First Name field, the record is empty. Let’s change that record by entering data in the fields.

  1. Click the Title field. A drop-down menu displays. Here, you can select a title. Select a value from the list. Notice that the field has a thin highlight around it. That’s how you can tell which field you are in.
  2. Click the First Name field. Enter your first name in the field.
  3. Click the Last Name field and enter your last name.
  4. Save the changes that you made to the record. In database terms, we refer to the act of saving changes to a record as committing the changes. To commit your changes, click anywhere in the content area of the window where a field or button isn’t present.


Adding a New Record

Let’s add a new record to the database. As you might have guessed, FileMaker Pro provides several ways to add records, including

  • Click the New Record button in the Status Toolbar.
  • Select the New Record command from the Records menu.
  • Use a keyboard shortcut. On a Mac, the shortcut is Command+N, and in Windows, it is Ctrl+N.

After you choose one of the previous methods, a new record is created. Again, with the exception of the First Name field, the fields are blank. Click the fields to enter some values.