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
10-30 FileMaker Pro User’s Guide
Working with related files and fields
The following sections explain how to work with data in related files
and fields.
Working with related files
Working with related fields
To do this with
related files Keep these points in mind
Work with passwords
and access privileges
You must have the appropriate access privileges to a related file or
field. For example, to add data to a related field, you must have the
privilege to edit records for the related file. (See “Protecting your
files” on page 7-8.)
Check spelling Check spelling of data in related fields just as you do with data and
text in the master file. (See “Checking your spelling” on page 1-13.)
Copy data When no fields and no records in a portal are selected, Copy copies
data in the master record and in all records in portals. When a record
in a portal is selected, Copy copies the data in the record in the portal.
(See “Copying and moving values and records” on page 4-12.)
Choose FileMaker Help Index from the Help menu, and then type:
E related files
To do this with
related fields Keep these points in mind
Change field
definitions
Change data entry options and validations directly in the related file
only, because the data is defined in the related file. (See “Changing
field definitions” on page 2-25.)
Change field formats Change the way data is displayed and formatted in the appropriate
layout of the master file. (See “Defining display formats for fields”
on page 3-58.)
Define a calculation
formula in the master
file that refers to a
related field
In the Specify Calculation dialog box, choose a relationship from
the relationship drop-down list. Then select a related field. (See
“Understanding formulas” on page 2-13.)
References to related fields can become invalid when you create or
delete a field, change the field type or number of repetitions, or have
a missing field definition or mismatched field types (for example,
when a field is deleted in the related file). When a field reference is
invalid, FileMaker Pro alerts you.
?