Using a Match Field to Choose a Related Record

Table of Contents

This Book

FileMaker Pro 7 Advanced for Windows and Macintosh: Visual Quickpro Guide

Search

Acknowledgments

Ch. 1. About FileMaker Pro 7

Ch. 2. Organizing Data Efficiently

Ch. 3. Layout Enhancements

Ch. 4. Calculation Fields

Ch. 5. Creating Data Reports

Ch. 6. Creating Relationships

About Relationships

Relationship Terminology in FileMaker Pro 7

Defining a Match Field

External File References

Creating a Match Field in the Current Table

Lookup vs. Related Fields

Using a Match Field to Choose a Related Record

Repeating vs. Related Fields

Creating Portals

Creating Related Data with Portals

Sorting Data in Portals

Summarizing Related Data

About Self-Relationships

Using a Portal for Navigation

Searching for Self-Relationship Data

Creating a Lookup with a Self-Relationship

Using Multi-criteria Relationships

Ch. 7. Creating Simple Scripts

Ch. 8. Working with Conditional Script Steps

Ch. 9. Extending the Interface with Scripts

Ch. 10. Script Troubleshooting

Ch. 11. Filemaker and Other Programs

Ch. 12. Importing Data

Ch. 13. ODBC/JDBC Import and Export

Ch. 14. Data Importing and Repairing

Ch. 15. Migrating to Version 7

Ch. 16. Multiuser Files on a Network

Ch. 17. Instant Web Publishing

Appx. A. FileMaker and Third-Party Software

Appx. B. FileMaker Resources

Index

Using a Match Field to Choose a Related Record

Once you have a relationship between two tables and have created Lookup fields (or added related fields to the layout), you can bring data from the source to the receiver table.

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Chapter 6. Creating Relationships > Using a Match Field to Choose a Related Rec...

Using a Match Field to Choose a Related Record