User manual

102 FileMaker Pro User’s Guide
mixing find and omit 28
multiple 28
narrowing criteria 27
operators in 23, 26
order of 29
repeating 29
reverting 29
Finding and replacing field values 30
Finding records
See also Find requests
adding new request 28
all records 24
Boolean numbers 26, 97
described 23
duplicate records 27
empty or non-empty fields 27
exact values 25
excluding records 28
invalid values 26
logical AND searches 27
logical OR searches 28
multiple criteria 27
omitting records 28
order of requests 29
partial or variable text 24
ranges of information 26
related fields and records 27
showing all records 24
symbols 24
today’s date 26
Footers, described 60
Form letters 55
Formatting
calculations 56
dates 57
export data 78
graphics 58
import data 76
numbers 56
text 56
times 57
timestamps 58
Forms
See also Layouts
Standard form layout 49
viewing records as 17
Formulas, calculation fields 41
Found set
described 17, 23
switching with omitted set 29
fp7 filename extension 15
Fraction of Total for summary fields 44
Full Access privilege set, described 83
Functions 42
Furigana field option 41
G
Global storage options 47
Grand summaries, described 60
Grand summary parts, described 60
Graphics, formatting fields for 58
Groups. See Accounts; Privilege sets
Guest account 83
H
Handicapped access 8
Headers, described 60
Hiding records 29
Host
database on web 79
described 73
FileMaker Server 73
performing tasks 75
saving files 73
I
Importing 76–79
adding new records 76
described 76
file formats supported 76
into existing files 76
source file or table 76, 77
target file 76
updating existing records 76
updating matching records 77
Indexing
fields 47
text field limitations 25
Instant Web Publishing
described 73, 79
sharing files 79
Intranet 79
See also Web
Invalid values, finding 26
IP addresses, limiting 79
J
JDBC
field name considerations 39
using with FileMaker products 7
Join expressions. See Relationships
Join fields. See Match fields
K
Key fields. See Match fields
L
Labels
See also Labels layout
field 55
sizes 50
vertical 50
Labels layout
See also Layouts
described 50
standard sizes 50
Layout mode, described 17
Layout objects. See Objects
Layout parts
body 60