User manual

I-14 FileMaker Pro User’s Guide
records on Web 14-13
related fields 3-9
related records 8-11
relationships in dialog box
8-11
repeating fields 3-9
summary fields 3-10
Sounds
copying 2-8
deleting 2-13
inserting into fields 2-12
on the Web 14-4
playing 2-13
recording 2-13
Source file, import 12-2
Space, removing blank 7-22
Spelling
See also Dictionaries
checking 2-14
options 2-14
setting preferences A-6
Splitting repeating fields 12-8
Spreadsheets
converting 12-6
importing 12-4
SQL 15-1
building queries 15-7
SQL join 15-8, 15-11
SQL Server 15-2
Stacking objects 7-18
Standard Deviation for summary
fields 5-7
Standard form layout
See also Layouts
described 6-3
Standard toolbar 1-5
Starting FileMaker Pro 1-6
Startup
options 10-2
scripts
described 10-2
performing A-5
Static web publishing 14-3
Status area
Browse mode 2-1, C-3
Find mode 3-6, C-3
Layout mode 6-11, C-3
showing/hiding 2-1, 6-12, A-5
Status functions
described 11-10
using in scripts 10-6
Steps. See Script steps
Stopping
See also Closing
lookups 8-13
scripts 10-2
Stored results 5-11
Strict data type 5-10
Strings, text. See Text, literal
Styles, in web views 14-11
Subforms. See Portals
Subscripts. See Scripts, subscripts
Subsummaries
See also Grand summaries;
Reports; Subsummary parts;
Summary fields
creating reports 6-3, 6-5
described 6-3, 6-26
exporting 12-8
printing 4-3, 4-4, 6-28
sorting subsummary values
3-9
viewing 6-28
Subsummary parts
See also Grand summary
parts; Subsummaries
described 6-26
page breaks 6-29
Subtotals. See Subsummaries;
Summary fields
Suffixes 2-11
Summaries. See Grand summary
parts; Subsummary parts;
Summary fields
Summarizing data in related
fields 8-12
Summary fields
Average for 5-7
Count for 5-7
defining 5-6
described 5-4, 5-6
exporting 12-7
find requests 3-2, 3-6
formulas 11-1
Fraction of Total for 5-7
importing 12-2
Maximum for 5-7
Minimum for 5-7
moving to 2-7
on layouts 6-26, 6-28
options for 5-7
sorting 3-10
Standard Deviation for 5-7
Total for 5-7
Summary functions 11-8
Summary parts. See Subsummary
parts; Grand summary parts
Switching layouts 6-8
SYLK format 12-1, 12-8
Symbols
exporting 12-6
finding 3-3
pasting 7-11
underscore 14-6
Symbols pop-up menu 3-2
Syntax
formulas 11-1
related field names 8-2
System formats. See Formats
T
Tab order
omitting fields 7-9
on the Web 7-9
repeating fields 7-9
setting 7-8
Table rights. See Access
privileges
Table View, Web
setting up 14-10
viewing in browser 14-15
Table View. See View as Table
Tables
controlling formatting 6-10
viewing records as 2-2, 6-4
Tables, database. See Files
Tabs
alignment 7-13
attributes 7-13
decimal 7-13
inserting in a field 2-7
setting 7-12, 7-13
Tab-Separated Text format 12-1
TCP/IP 14-5, A-2
Templates
creating files 5-2
described 5-2
displaying A-2
suppress New Database dialog
box 5-2
Text
See also Fields
adding 2-7, 2-13
adding to a layout 7-10
alignment 7-13
attributes 6-22, 7-12
baselines 7-2
boundaries, showing/hiding
7-17
changing appearance 7-14
color 7-12, 7-14