Go to Related Record: navigation and found sets

Expert

Use Go to Related Record to navigate to related data and understand how "Show only related records" controls the destination found set.

What you'll learn

The difference between GTRR with and without "Show only related records"
How to use GTRR to navigate to a specific related record on a different layout
How GTRR interacts with the found set and record count

Go to Related Record (GTRR) is one of the most powerful navigation steps in FileMaker. It navigates to a related record and optionally creates a found set of all related records. Misunderstanding the "Show only related records" option is one of the most common sources of found-set bugs in scripted workflows.

1/3

GTRR with "Show only related records" checked

FileMaker performs a find that limits the found set at the destination to only the records related to the current anchor record. This is the most common option for drilling down from a parent to its children.

FileMaker Script

// Button or script on an Invoice record:
// GTRR: Show only related records checked
// From table: LineItems, Using layout: "Line Items List"
// → Navigates to the Line Items layout
// → Found set: only line items for the current Invoice

Global fields in relationships: dynamic joins Cascading deletes and relationship delete options