Help

FILEMAKER PRO HELP 1270
In addition to fields placed in a portal, FileMaker Pro uses this method to determine the starting point
for other references to fields in portals:
• Value lists: when a value list is defined to include only related values from a field, and a field
in a portal is formatted to display this value list. (The starting point determines the values
displayed in the value list.)
• Calculations: when scripted calculations refer to fields while a portal is active.
Usually, FileMaker Pro determines the correct related data to display. However, you can change the
starting point by modifying the relationships graph to include other tables and relationships, and then
changing the related fields referenced in the portal.
Related topics:
Adding fields to a layout
Placing and removing fields on a layout
Creating portals to display related records
Working with related tables and files
Example of a value list that includes only related field values
About URL encoding in web viewers
FileMaker Pro evaluates a web viewer's web address, encodes the URL by default, then tries to
load the web page using this URL. FileMaker
Pro uses the following URL encoding rules to fix only
the most common problems:
• The following characters are never automatically encoded:
ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz
0123456789-_.~!*'();:@=+$,/?[]
Placed field
Path from
layout’s table to
field’s table
Does path
include
portal’s table?
Starting
point Comment
Name field from
Students table
Classes-Enrollment-
Students
Yes Portal’s
record
The placed field is from the portal’s
table (a very common occurrence).
The field would display an enrolled
student in each row of the portal.
Name field from
Advisors table
Classes-Enrollment-
Students-Advisors
Yes Portal’s
record
The placed field would display each
student’s advisor in each row of the
portal.
Name from
Teachers table
Classes-Teachers No Layout’s
record
The placed field would repeat the
teacher for the class in each row of
the portal, not the first related
teacher value for each student.
Class Name
from Classes
table
Classes No Layout’s
record
The placed field is from the layout’s
table (an uncommon occurrence).
The field would repeat the class
name for each row in the portal,
which is redundant if the layout
includes the Class Name field
outside of the portal.