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-34 FileMaker Pro User’s Guide
Deleting related records
While browsing through records in a master file, you can delete records
from a related file when one or both of the options for deleting records
are selected.
Important You can’t undo deleting data or records. Before deleting,
consider making a backup copy of your files.
To delete records, in Browse mode, choose Delete Record from the Mode
menu. (See “Deleting records” on page 4-28.) FileMaker Pro deletes
information based on the following:
1 When a portal row is selected (by clicking inside the row but outside any
fields in the row) and Allow deletion of portal records is selected in the
Portal Setup dialog box, FileMaker Pro deletes the associated related
record. (See “Creating a portal to hold related fields” on page 10-23.)
1 When anything other than a portal row is selected, FileMaker Pro
deletes the master record. If When deleting records in this file, also delete
related records is selected in the Edit Relationship dialog box, all
related records are also deleted. (See “Defining relationships for a
relational database” on page 10-21.)
Note Delete All deletes the records in the found set of the master file. If
When deleting records in this file, also delete related records is selected for the
relationship, FileMaker Pro also deletes the related records.
Finding and omitting related records
You can include related fields in find criteria when you find records in a
master file. (For more information, see “Finding information” on page
4-19 and “Omitting records” on page 4-25.)
When you find records using related fields in a portal, FileMaker Pro
displays all records related to the found set of records in the master file,
not just related records that satisfy the find criteria. For example,
suppose you search for records whose Item field (which is in a portal)
contains Computer. The found set includes all records in the master file
that contain Computer in any row of the portal.
You can omit master records that include related fields, but you can’t
omit related records.
Choose FileMaker Help Index from the Help menu, and then type:
E related records
?