U.M. (Mac OS)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- _
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- _
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Index
I-6 FileMaker Pro User’s Guide
Fill attributes
color 3-51
described 3-53
pattern 3-73
setting 3-51, 3-52
Financial functions C-13
Find criteria 4-19
Find mode 1-7
Find requests
See also Finding
defining 4-19
deleting 4-26
described 4-19
editing 4-25, 4-26
mixing find and omit 4-27
multiple 4-25
operators in 4-20
order of 4-27
repeating 4-25, 4-26
reverting 4-21
summary fields in 4-20
Finding
See also Find requests
all records 4-25
Boolean numbers 4-24
dates 4-24
described 4-19
duplicate records 5-34
duplicate values 4-20
empty fields 4-20
errors 4-19
exact values 4-20, 4-21
graphics 4-22
invalid dates and times 4-20
numbers 4-24
operators 4-20
order of requests 4-27
ranges 4-20
records 4-19
records using related fields 10-34
text 4-23
times 4-24
today’s date 4-24
Flat-file databases 1-6
Fonts
text ruler 3-85
Footers
described 3-25
printing 6-1
Form letters 3-58
Form View, Web
setting up 11-12 to 11-18
viewing in browser 11-16
format files 11-2, 11-4, 11-6, 11-25,
to 11-28
Formats
See also File formats; System
formats
default 3-60
display 3-60
internal default B-1
international 3-60, B-1
system B-1
Formatting
calculations 3-62
custom line spacing 3-88
export data 8-4, 8-11
fields
as selected 3-68
defaults 3-60
sample data 3-57
text 3-60
graphics 3-67
import data 8-4
merge fields 3-58
paragraphs 3-84
repeating fields 3-72
scroll bars 3-71
text 3-88
times 3-65
Forms
See also Layouts
printing 6-1, 6-12
Formulas
See also Calculation fields;
Summary fields
calculation fields 2-20
changing 2-25
constants 2-15
described 2-13
expressions 2-15
field references 2-16
functions C-1
operators 2-16
results 2-14
syntax 2-14
Found set
copying 4-29
deleting 8-8
described 4-4, 4-19
import data 8-8
switching with omitted set 4-27
Fraction of Total for summary
fields 2-23
Functions
aggregate C-6
date C-5
described 2-20
design C-18
financial C-13
logical C-14
number C-4
parameters C-1
repeating C-12
status 5-33, C-16
summary C-9
text C-3
time C-6
trigonometric C-13
Web Companion C-19
G
Getting help. See Help
Global fields
See also Fields
defining 2-9
described 2-5, 2-9
examples 5-34
importing 8-4
shared files 7-6
Glossary in Help XII
Grand summaries
described 3-29
exporting 8-13
Graphic
objects
adding to layouts 3-54
described 3-52
rulers
described 3-40
showing/hiding 3-41
Graphics
copying 4-13
deleting 4-8
finding 4-22
importing 4-6
pasting 4-8
positioning 3-44
rotating 3-49
storing methods 4-6
viewing on the Web 3-3
Graphs, with FileMaker Pro data 8-1