U.M. (Mac OS)
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
- Index
Using data from related files 10-23
6. Select options for the relationship.
7. Click OK, and then click Done.
Keep these points in mind:
1 A match can be defined only on fields that can have an index.
1 You can define a relationship when you add a related field or create
a portal in a layout. See the following sections.
1 To change a relationship, see “Changing relationships” on page
10-29.
Creating a portal to hold related fields
Important Before you begin, be sure you want to create a portal to hold
related fields. (See “Deciding where to place related fields” on page
10-20.)
1. In Layout mode in the master file, select the Portal tool.
To do this while browsing
records in the master file Select
When you delete a record in the master
file, delete related records (in the
related file)
When deleting a record in this file, also delete related
records. (See “Deleting related records” on page
10-34.) Related records may not be visible on the
current layout.
Add records to the related file Allow creation of related records. (See “Creating
related records” on page 10-32.)
Sort related records before displaying
them in the master file
Sort related records, then specify how you want
related records sorted. (See “Sorting records
with related fields” on page 10-35.)
Choose FileMaker Help Index from the or Help menu, and then type:
E relational databases
?