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
Using data from related files 10-3
Understanding lookups
You look up data by first setting up a relationship between matching
data in the master file and a related file, and then defining a lookup to
copy data from a field in the related file into a field in the master file.
When you type a value in the match field of the master file,
FileMaker Pro uses the relationship to find the first record in the related
file whose match field contains a matching value. Next, it copies the
value from the lookup source field into the lookup destination field,
where the value is then stored. Data that’s copied into the master file
doesn’t change when the value in the related file changes, unless the
match field in the master file is changed. In that case, the lookup will be
performed again.
Lookup destination field
(for lookups only)
A field in the master file that you want to contain the copied data.
It’s the field the data is copied to.
Relationship An expression you define that contains requirements which, when
met, establish a relationship between values in the match fields. (A
relationship is sometimes called a link or a join expression.)
Related record A record in the related file whose match field (according to the
relationship used) contains a value that’s equal to the value in the
match field of the master file.
Related field A field in the related file that contains data you want to access and
work with in the master file. After a relationship has been
established between data in the match fields, the data in a related
field can then be used in the master file.
You place a related field in a layout of the master file, either by
itself or in a portal. You can then work with the related data in all
modes.
In the master file, a related field name appears as Relationship
name::Related field name or as::Related field name
Portal An object in a layout of the master file in which you can place
related fields. Use a portal when you want to access and work with
data from more than one related record in records of the master
file.
You only need to place related fields in a portal if you want to work
with data from more than one related record.
Portals display data from related records in rows, one record in
each row.
This term Means