Go to Related Record: navigating via relationship in FileMaker

Intermediate

Go to Related Record (GTRR) is one of the most powerful navigation steps in FileMaker — and one of the easiest to misuse. Learn how to navigate to related records correctly and what "show only related records" actually does.

What you'll learn

  • How GTRR navigates to a related record or opens a related layout
  • What "Show only related records" does to the found set
  • When to use GTRR vs a scripted find

Go to Related Record navigates from the current record to one or more related records, optionally filtering the found set to show only those records.

1/3
1

Configure Go to Related Record

In the step options, specify the relationship to traverse and the layout to navigate to. FileMaker will go to the first related record via that relationship.

FileMaker Script
# Example: from an Invoice record, go to the related Customer
Go to Related Record [ From table: Invoices ; Using layout: "Customer Detail" (Customers) ]

# FileMaker navigates to the related Customers record
# and opens the "Customer Detail" layout
Perform Script on Server (PSOS): when to use it and how it worksNew Record and Delete Record script steps

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo