Skip to Main Content
FileMaker Pro 14: The Missing Manual
book

FileMaker Pro 14: The Missing Manual

by Stuart Gripman, Susan Prosser
May 2015
Beginner to intermediate content levelBeginner to intermediate
970 pages
32h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 14: The Missing Manual

Chapter 15. Advanced Relationship Techniques

In Chapter 14, you learned how to use the tools in FileMaker Pro Advanced to make your development tasks—like debugging your database and creating custom menus—easier. That’s a great start on thinking like a developer. Now it’s time to turn your attention back to relationships and delve into some of the more powerful features in the Relationships graph. Your first relationships, like the ones you created on Understanding the Elements of a Relationship, were of the most basic type: They used a single key field pair, and the value in those key fields matched exactly. But you can also create relationships that work when values don’t match, by using an operator other than the = sign. And just as you can add more criteria to a search, you can also add multiple criteria to a relationship. You do that for the same reason you add more criteria to a search: because you want the results to be more specific, as when you need a customer ID and a date field each to match corresponding fields in a related table. And just as you can sort a portal separately from the underlying relationship’s sort order, the Portal Setup dialog box also lets you filter related records to show only some related records.

You’ll also delve deeper into table occurrences. FileMaker lets you create as many instances of a table as you need on the graph. Once you know about more complex joins, you have the tools you need to start making those multiple table occurrences. But as ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

FileMaker Pro 11: The Missing Manual

FileMaker Pro 11: The Missing Manual

Stuart Gripman, Susan Prosser
FileMaker Pro 12: The Missing Manual

FileMaker Pro 12: The Missing Manual

Susan Prosser, Stuart Gripman
FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

Susan Prosser, Geoff Coffey
FileMaker Pro 9: The Missing Manual

FileMaker Pro 9: The Missing Manual

Geoff Coffey, Susan Prosser

Publisher Resources

ISBN: 9781491917473Supplemental ContentErrata Page