U.M. (Windows)
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
- Appendix D: Linking and embedding objects
- Index
I-6 FileMaker Pro User’s Guide
protecting 7-8
recovering A-1
related 1-6, 10-1
saving 1-11
security 7-8
shared
access privileges 7-8
closing 7-7
cross-platform D-12
described 7-1
guests 7-1, 7-4
host 7-1, 7-3
OLE objects D-12
on remote volumes 7-3
on Web 7-3, 11-1, 11-6, 11-7
preferences 9-8
requirements 7-1
saving 7-5, 7-7
system formats B-1
templates
creating files 1-9
described 1-9
displaying 9-2
updating to current version 1-11
Files, external. See Exchanging files
Files, master. See Master file
Fill attributes
color 3-50
described 3-51
pattern 3-72
setting 3-50
Financial functions C-12
Find criteria 4-19
Find mode 1-7
Find requests
See also Finding
defining 4-19
deleting 4-25
described 4-19
editing 4-25
mixing find and omit 4-26
multiple 4-24
operators in 4-20
order of 4-26
repeating 4-25
reverting 4-21
summary fields in 4-20
Finding
See also Find requests
all records 4-24
Boolean numbers 4-23
dates 4-23
described 4-19
duplicate records 5-26
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-23
operators 4-20
order of requests 4-26
ranges 4-20
records 4-19
records using related fields 10-34
text 4-22
times 4-24
today’s date 4-24
Flat-file databases 1-6
Fonts
text ruler 3-83
Footers
described 3-25
printing 6-1
Form letters 3-56
Form View, Web
setting up 11-12 to 11-18
viewing in browser 11-16
format files 11-2, 11-4, 11-6, 11-24,
11-25
Formats
See also File formats; System
formats
default 3-58
display 3-58
internal default B-1
international 3-58, B-1
system B-1
Formatting
calculations 3-60
custom line spacing 3-86
export data 8-4, 8-11
fields
as selected 3-67
defaults 3-58
sample data 3-55
text 3-59
graphics 3-65
import data 8-4
merge fields 3-57
paragraphs 3-82
repeating fields 3-71
scroll bars 3-70
text 3-86
times 3-64
Forms
See also Layouts
printing 6-1, 6-11
Formulas
See also Calculation fields;
Summary fields
calculation fields 2-20
changing 2-25
constants 2-14
described 2-13
expressions 2-14
field references 2-15
functions C-1
operators 2-15
results 2-14
syntax 2-14
Found set
copying 4-28
deleting 8-8
described 4-4, 4-19
import data 8-8
switching with omitted set 4-26
Fraction of Total for summary
fields 2-23
Functions
aggregate C-6
date C-5
described 2-20
design C-18
external C-19
financial C-12
logical C-14
number C-4
parameters C-1
repeating C-11
status 5-25, 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-26