Skip to Main Content
FileMaker Pro 9: The Missing Manual
book

FileMaker Pro 9: The Missing Manual

by Geoff Coffey, Susan Prosser
August 2007
Beginner to intermediate content levelBeginner to intermediate
799 pages
28h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 9: The Missing Manual

Changing Multiple Records

Sometimes the whole reason you performed a find is to change something in several records. If one of the companies you work with changes its name, you may have several records that need to be updated. The first step to fixing them is to find them. Once your found set includes the people at that company, you could change the Company Name field one record at a time (especially if you’re billing by the hour). But a better use of your time is to use the Replace Field Contents command. Here’s how it works:

  1. Click in the Company Name field (it doesn’t matter which record), and correct the company name.

    You’ve just fixed one of the records. All the others in the found set need the same fix. (Make sure you’re still in the Company Name field or the next step won’t work.)

  2. Choose Records → Replace Field Contents.

    The Replace Field Contents dialog box appears (Figure 2-6). It has a handful of options that may not make sense to you yet. That’s OK; just choose the first one: “Replace with.” The new data you just typed is listed beside this option.

    The Replace Field Contents dialog box has three options: “Replace with,” “Replace with serial numbers,” and “Replace with calculated result.” The first option is the only one you’re concerned with right now. It replaces the contents of the current field in every record in the found set with whatever is in the current record when you click Replace. So, in the current record, type what you want to be in every record before you call up this dialog box. (You’ll learn about serial numbers in and calculations in .)

    Figure 2-6. The Replace Field Contents dialog box has three options: “Replace with,” “Replace with serial numbers,” and “Replace with calculated result.” The first option is the only one you’re concerned with right now. It replaces the contents of the current field in every record in the found set with whatever is in the current record ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

Susan Prosser, Geoff Coffey
FileMaker Pro 13: The Missing Manual

FileMaker Pro 13: The Missing Manual

Susan Prosser, Stuart Gripman
FileMaker Pro 11: The Missing Manual

FileMaker Pro 11: The Missing Manual

Stuart Gripman, Susan Prosser
FileMaker Pro 14: The Missing Manual

FileMaker Pro 14: The Missing Manual

Stuart Gripman, Susan Prosser

Publisher Resources

ISBN: 9780596514136Supplemental ContentErrata Page