U.M. (Windows)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Appendix D: Linking and embedding objects
- Index
Working with information in records 4-15
Replacing field values
You can replace the contents of a field in all or some records with a
different value (for example, replace the value Production Artist with
Production Specialist), a new series of serial numbers (when, for
example, records have become disordered), or an expression. You can
also modify a field’s existing values by using an expression that includes
the field (for example, change the value Gross Pay to the expression
Gross Pay + 1000).
Before you begin, keep these points in mind:
1 You can’t replace calculation, summary, or global fields.
1 You can’t reserialize calculation, summary, global, or container fields.
1 You may want to sort records before you reserialize them. For
example, sort suppliers by how frequently you use them, and then
reserialize the records. (See “Finding information” on page 4-19,
“Omitting records” on page 4-25, and “Sorting records” on page 4-29.)
1 To replace data in fields in only a few records, go to each record and
change the value by selecting the contents of the field and then typing
the information you want.
Important You can’t undo replacing field values. Before you begin,
consider making a copy of the file.
To replace field values:
1. In Find mode, find the records whose data you want to replace.
2. If you want the data in a specific order, in Browse mode, sort
the records.
3. In Browse mode, in the current record, select the contents of the field
whose values you want to replace.
4. If you’re replacing data (not assigning serial numbers), type the value
to replace the current data with.
5. Choose Replace from the Mode menu.