Functions Reference

232 FileMaker Functions Reference
Sort order
The sequence for rearranging records. Records are sorted by the first field in the sort
order list, then the second, and so on. Values within each field are sorted by the order
specified (ascending, descending, or custom).
Source file
The file from which you bring data during importing or exporting, or the file from which you
add a table to the relationships graph.
Source table
The table upon which one or more tables in the relationships graph are based. The source
table is the table defined in the Tables tab of the Manage Database dialog box.
SQL
A structured programming query language that controls and interacts with a DBMS.
Stacking order
The order in which objects overlap on a layout. You can change this order by cutting and
pasting objects or by choosing Arrange menu > Bring to Front, or Bring Forward, or Send
to Back, or Send Backward in Layout mode.
Standard Form layout
The default layout, with all fields arranged on separate lines in the order they were
defined. The body part is only as tall as it needs to be to include all the fields in the
database. This layout includes header and footer parts.
Startup script
A script that automatically runs when a file is opened. You can script such things as setting
system formats to the user's formats or setting a database to be shared in a startup script.
You specify a startup script in the File Options dialog box.
Status area
The area at the left side of the document window that displays the book and status
information. In Find mode, the status area includes Find buttons. In Layout mode, it
includes tools and controls for drawing, and working with fields, layout parts, buttons, and
portals.
Submenu
A menu that extends from another menu item.
Sub-script
A script that is called from another script.