User manual

Index 105
match fields 63
planning 64
planning 35, 68
portals 63
related tables
described 63
planning 35
terminology 63
Relational operators 63, 66, 70
Relationships
See also Relational databases
changing 69
comparative 66
creating 68
described 63
multi-criteria 65
planning 37
returning range of records 67
self-joining 68
single-criteria 64
types 64
Relationships graph 63, 64, 69
described 69
Repeating find requests 29
Reports
See also Layouts; Subsummaries
Columnar list/report
creating 48
previewing 31
records in columns 51
with grouped data
creating 49
printing 32
Restricting access. See Accounts; Privilege
sets
Retrieving data from other files. See Exchang-
ing files
Reverting find requests 29
Rights. See Accounts; Privilege sets
S
Saving
data automatically 16
files 16
shared files 73
Screen readers 8
Scripts
converting scripts that switch windows 97
copying 16
described 34
performing 34
printing 33
Searching. See Finding records
Secondary files. See Relational databases
Security, file
planning 84
Selecting
objects 53
records 19
Selection tool 53
Self-joins 68
for summarizing data in portals 70
Server. See Host; FileMaker Server
Settings. See Preferences
Shared files
See also Networks
accounts 84
clients 73
host 73
in workgroups 79
limitations 73
on web 79
opening 14
privilege sets 84
saving 73
Single-page form layout. See Standard form
layout
Slider 19
Sorting
records 25, 31
records in table format 18
related records 70
Standard Deviation for summary fields 43
Standard form layout
See also Layouts
described 49
Stopping lookups 72
Stored results 47
Strict data type 46
Strings, text. See Text, literal
Subforms. See Portals
Subsummaries
See also Reports; Subsummary parts;
Summary fields
creating reports 49
printing 31, 32
Subsummary parts
See also Subsummaries
described 60
Subtotals. See Subsummaries; Summary fields
Summaries. See Subsummary parts; Summary
fields
Summarizing data in related fields 70
Summary fields
Average for 43
Count for 43
defining 43
described 40, 43
Fraction of Total for 44
Maximum for 43
Minimum for 43
on layouts 60
options for 44
Standard Deviation for 43
Total for 43
Summary parts. See Subsummary parts
SYLK format 76
Symbols
finding 24
underscore 39
Symbols pop-up menu 23