User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Saving find requests
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Defining database fields
- Using supplemental fields
- Setting options for fields
- Defining database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases with accounts and privilege sets
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Chapter 8 Security measures
- Index
212 | Index
Related fields
See also Fields; Relational databases
calculations 86
described 135
on layouts 118
planning 75
summarizing data 150
Related files, restricting access 77
Related records
See also Records; Relational databases
adding 36, 149
copying 36
deleting 37, 149
described 135
displaying in portals 120
duplicating 36
finding and omitting 49
sorting 149
summarizing data 150
Related tables
described 136
planning 71
Relational databases
described 21, 131
match fields 135
planning 137
planning 71, 145
portals 135
related tables
described 136
planning 71
terminology 135
Relational operators 136, 142, 149
Relationships
See also Relational databases
changing 148
comparative 142
creating 145
described 136
multi-criteria 140
planning 76
returning range of records 143
self-joining 144
single-criteria 138
types 138
Relationships graph 136, 147
described 146
Repeating find requests 55
Reports
See also Columnar list/report layout;
Layouts; Subsummaries
creating 99
previewing 60
records in columns 106
with grouped data
creating 102
printing 61
Restricting access. See Accounts; Privilege
sets
Retrieving data from other files. See
Exchanging files
Reverting find requests 55
Rights. See Accounts; Privilege sets
S
Saving
data automatically 26
files 26
shared files 157
to Excel and PDF formats 163
Scripts
copying 27
described 17, 68
performing 68
printing 66
φμπ10_υσερσ_γυιδε.βοοκ Παγε 212 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ