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-28 FileMaker Pro User’s Guide
Copying and pasting related fields and portals
Choosing a different relationship for a portal
1. In Layout mode, double-click the portal.
2. In the Portal Setup dialog box, choose a relationship from the drop-
down list, and then click OK.
If you change the relationship after adding related fields to the portal, the
fields don’t change, but FileMaker Pro matches records based on the
new relationship. Remove the fields from the portal, and then add related
fields based on the new relationship, if needed.
Changing relationships
When you change a relationship, your changes affect which records are
found in the related file and displayed in records of the master file.
When you delete or change a relationship, all records involved in that
relationship are affected by your changes.
1. Choose Define from the File menu, and then choose Relationships.
To Do this in Layout mode
Cut, copy, and paste
related fields
See “Cutting, copying, and pasting objects” on page 3-44. If you
paste a related field into another file, FileMaker Pro looks for a
matching related field name in the new file. If the matching name
exists, FileMaker Pro pastes the field in the layout with that same
name. Otherwise, a template field (a field with no association to any
field in the database file) is pasted.
Copy and paste portals See “Cutting, copying, and pasting objects” on page 3-44. To copy
and paste related fields with a portal, select the fields and the portal.
If you paste a portal into another file, FileMaker Pro looks for a
matching relationship name in the new file.