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-36 FileMaker Pro User’s Guide
2. Select related fields in the order you want them sorted, and then
click Sort.
Note You can place a related field anywhere in the field order—before,
after, or between fields in the master file.
Sorting related records
You can sort related records before displaying their values in the master
file. Normally, FileMaker Pro looks in the related file, finds the first
record that matches according to the specified relationship, and displays
the related values in the master file. However, you can have
FileMaker Pro sort related records first, and then display values from
those sorted records in the master file. Instead of displaying the first
related record, FileMaker Pro displays the first value encountered after
sorting. The displayed value could be a highest value, a lowest value, or
a value sorted using a custom order based on a value list.
Sorting related records is especially useful if you are using a portal to
display multiple related records. You can use this feature to have related
records appear in the portal in the sorted order you specify.
1. Choose Define from the File menu, and then choose Relationships.
2. Select the relationship you want to work with.
3. Click Edit.
4. In the Edit Relationship dialog box, select Sort related records.
5. In the Specify Sort dialog box, define how you want fields in the
related file to be sorted before they are displayed in the master file.
Invoicing example
The following sections contain a step-by-step example for setting up a
relational invoicing system, using a sample travel agency named
EveryWhere Travel.
Choose FileMaker Help Index from the Help menu, and then type:
E related fields
E sorting records
?