Database Reference
In-Depth Information
▪ If you don't turn on “Show only related records,” then FileMaker goes to the related
table, but you see all the records in the related table, not just those that are related to the
formerly active record. The first related record is active in your new found set. So, from
the Customer layout, GTRR without “Show only related records” shows all your jobs,
and the active record is the first one for the customer that you're viewing when the
GTRR script step runs.
▪ If you turn on “Show only related records” and “Match current record only,” then
FileMaker returns a found set of only those records that match the active record. The cus-
tomer job GTRR set, as described above, shows you a found set of just the jobs for the
customer record that was active when the script step ran. The active record will be the
first related record.
▪ Choosing “Show only related records” and “Match all records in current found set” is
most useful when you have a found set selected before the GTRR script step runs. In this
scenario, FileMaker shows a new found set in which all the records are related to at least
one of the records in the old found set. So, in the Customers layout, you've found your
two highest-volume customers. Use GTRR, matching all records in the current found set
to find all the invoices related to either of these two customers. The active record will be
the first record that's related to the customer record that was active when the GTRR
script step runs.
