User manual

|
Index 115
Related tables
described 71
planning 39
Relational databases
described 14, 69
match fields 71
planning 72
planning 39, 76
portals 71
related tables
described 71
planning 39
terminology 71
Relational operators 71, 74, 78
Relationships
See also Relational databases
changing 78
comparative 74
creating 76
described 71
multi-criteria 73
planning 41
returning range of records 75
self-joining 76
single-criteria 72
types 72
Relationships graph 71, 72, 77
described 77
Repeating find requests 32
Reports
See also Columnar list/report layout; Layouts;
Subsummaries
creating 53
previewing 35
records in columns 57
with grouped data
creating 55
printing 35
Restricting access. See Accounts; Privilege sets
Retrieving data from other files. See Exchanging
files
Reverting find requests 32
Rights. See Accounts; Privilege sets
S
Saving
data automatically 16
files 16
shared files 81
to Excel and PDF formats 84
Screen readers 7
ScriptMaker 37
Scripts
converting scripts that switch windows 108
copying 16
described 37
performing 37
printing 36
Searching. See Finding records
Secondary files. See Relational databases
Security, file
planning 94
Selecting
fields 22, 59
objects 59
records 19
Selection tool 59
Self-joins 76
for summarizing data in portals 79
Server. See Host; FileMaker Server
Settings. See Preferences
Shared files
See also Networks
accounts 94
clients 81
host 81
in workgroups 88
limitations 81
on web 88
opening 14
privilege sets 94
saving 81
setting up privileges for 92
Single-page form layout. See Standard form layout
Slider 20
Sorting
records 26, 33
records in table format 18
related records 78
Sound files 45
SQL 11
using with FileMaker products 7
Standard Deviation for summary fields 48
Standard form layout
See also Layouts
described 55
Starter Solutions. See Templates
Status area 17
Stopping lookups 80
Stored results 52
Strict data type 51
Strings, text. See Text, literal
Subforms. See Portals
Subsummaries
See also Reports; Subsummary parts;
Summary fields
creating reports 55
printing 35
Subsummary parts
See also Subsummaries
described 68
Subtotals. See Subsummaries; Summary fields
Summaries. See Subsummary parts; Summary
fields
Summarizing data in related fields 79
Summary fields
Average for 48
Count for 48
defining 48
described 45, 48
Fraction of Total for 48
Maximum for 48
Minimum for 48
on layouts 68
options for 48
Standard Deviation for 48
Total for 48
Summary parts. See Subsummary parts
SYLK format 85