Script Steps Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Control script steps
- Chapter 3 Navigation script steps
- Chapter 4 Editing script steps
- Chapter 5 Fields script steps
- Set Field
- Set Next Serial Value
- Insert Text
- Insert Calculated Result
- Insert From Index
- Insert From Last Visited
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert Picture
- Insert QuickTime
- Insert Object (Windows)
- Insert File
- Update Link (Windows)
- Replace Field Contents
- Relookup Field Contents
- Export Field Contents
- Chapter 6 Records script steps
- Chapter 7 Found Sets script steps
- Chapter 8 Windows script steps
- Chapter 9 Files script steps
- Chapter 10 Accounts script steps
- Chapter 11 Spelling script steps
- Chapter 12 Open Menu Item script steps
- Chapter 13 Miscellaneous script steps
- Appendix A Glossary
32 FileMaker Script Steps Reference
• Match all records in the current found set creates a new found set in the related
table that matches all records in the current found set. For example, if you have a
found set of ten customers and there are forty invoices in the invoice table that match
any of these ten customers, use Match all records in the current found set to
display the forty matching invoices.
Web compatibility
This script step is web-compatible.
Description
Goes to the current related record(s) in a related table, except when this script step is used
from an active portal row.
If this script step is used from an active portal row, and the portal’s table is the related
table, then the related record in that table is made current. If the portal’s table is not the
related table, the first related record in the found set is made current.
You have the option to view the related records in a new window. This script step requires
a relationship to be in effect.
For example, suppose you have an Invoices table that's related to a Customers table and
you're currently looking at a particular invoice. In the Invoices table, you have a button
that's set to Go to Related Record [Customers] . Clicking this button determines which
customer record your current invoice is related to and immediately goes to that record in
the Customers table. If the record in question is not currently in the Customers table’s
found set, the script can perform a find to make the record current.
This script step also works with portal rows. If the currently active portal row is row #3 and
you execute a Go to Related Record script step using the same relationship as the portal,
then FileMaker Pro goes to that particular related record in the related table.
When used with a table in an external file, this script step will open the file containing the
external table and, if selected, go to the external layout you specify.
Note To bring the new window with the related record(s) to the front automatically, add the
Select Window script step on page 80.
Examples
The following goes to a related record in the table "MyRelatedTable".
Go to Related Record [From table: "MyRelatedTable";
Using layout: “MyLayout”]
The following goes to a related record in the table "MyRelatedTable" and shows a found
set of related records only.
Go to Related Record [Show only related records;
From table: "MyRelatedTable"; Using layout: “MyLayout”]