Quick Explanation Of FileMaker GTRR

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit. For the best experience, please visit the journal directly by clicking (here). 

You gotta love those computer terms ... you gotta hate those computer terms.

GTRR is an acronym for Go To Related Record, much like TGIF ( thank god it’s Friday). GTRR is very often an overlooked script step by fledgling FileMaker developers until they use it a time or two. GTRR allows you to do a number of impressive operations including using GTRR as an alternative to performing a search. GTRR, in many ways, is like doing a find. In fact many developers use GTRR instead of scripted finds ( this particular developer included ). Scripted finds can be a little messy but GTRR actions can be squeaky clean.

By scripted finds, I mean a script that has to perform a FIND operation to get a set of records to work on. There are two types of scripted finds. The first is where you are always looking for the same thing, such as invoices that are overdue. The second is where the user enters in some variable to perform a search ... but this is done inside of a script ... because there are other steps the script does on either side of the Find operation. The main downside to using a GTRR instead of a find to get a found set is that you have to define a relationship for each different GTRR operations.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.