Database Reference
In-Depth Information
jobs) in a sorted found set on the Jobs layout? It would take a bunch of steps if you had to do
it manually. But the “Go to Related Record” command does all those steps for you—when
you add a few new options to the setup you just learned.
1.
On the Customers layout, switch to Layout mode and then select the Jobs::Name
field
.
It's in the Jobs portal.
2.
Choose Format
→
Button Setup. In the Button Setup dialog box, from the list, se-
lect the “Go to Related Record” command and then click Specify
.
The “Go to Related Record” Options window pops up.
3.
From the “Get related record from” pop-up menu, choose Jobs. From the “Show
record using layout” pop-up menu, choose Layout, then choose the Jobs layout
and then click OK once
.
You need a layout that shows you meaningful data from the Jobs table. So far, this
process is just like creating a “Go to Related Record” button without a found set. The
next steps make all the difference.
4.
Turn on “Show only related records.”
When you turn on “Show only related records,” FileMaker changes the found set in
the target table, showing just the related records. The appropriate record (the one you
clicked on) will be active, and you'll be able to scroll to the other records in the found
set. If the relationship has a sort order, FileMaker sorts the found set, too.
For now, leave “Match current record only” turned on. (Selecting “Match all records
in the current found set” lets you go from one found set of records to another. See the
box below for more detail.)
5.
Click OK until you're back on the Customers layout
.
You're looking at your layout again.
6.
For good measure, make sure the Jobs::Name field is blue and underlined (so it
looks like a link)
.
Training time is cut down when you provide clues that the field is clickable.
Switch to Browse mode to admire your work. Now you have a way to move from a Job to its
Customer and from a Customer to a found set of all her Jobs. To see the real power of a but-
ton in a portal, use the topic icon to navigate to a customer record that has more than one re-
lated job. Click the
second
portal record. Since you're on the second row, the button takes
