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
- Quick Reference
10-14 FileMaker Pro User’s Guide
Keep these points in mind:
1 You can define a relationship for a lookup when you define the
lookup. See the previous section.
1 To change a relationship, see “Changing relationships” on page 10-28.
Updating lookup values
If you change data in the match field of the related file or in the lookup
source field, FileMaker Pro doesn’t automatically update the data in the
lookup destination field. To update the data, you need to look it up again.
Important You can’t undo your actions when you update lookup values.
1. In the master file, locate the records that contain the values to update.
If necessary, find or omit records first. (See “Finding information” on
page 4-19 and “Omitting records” on page 4-25.)
2. Select the match field in the current file, and then choose Relookup
from the Mode menu.
3. When you see an alert message, click OK.
To define a script to update lookup values automatically, see chapter 5,
“Using ScriptMaker and buttons.”
Working with relational databases
The rest of this chapter explains how to plan, create, and work with
relational databases.
Important Before you begin, be sure you understand the information in
the previous sections that explain relational databases and how they
differ from lookups.
Choose FileMaker Help Index from the Help menu, and then type:
E lookups, defining
Choose FileMaker Help Index from the Help menu, and then type:
E lookups, updating
?
?