User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 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
- 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
- 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 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
14 FileMaker Pro User’s Guide
A database can consist of one file with one table, which might hold
the names, addresses, and telephone and fax numbers of all your
clients.
A database can also consist of several files, each of which can contain
one or more tables that, together, contain all the information about
related topics (sometimes called a database system). Using the
relational capabilities of FileMaker
Pro, you can join information
between files and tables to create a
relational database.
For example, one table can show you which clients bought a
particular item and a related table can show how much they paid.
To enter data in a database table, you make a new record and enter
values into the fields that belong to that record. Values can be typed
into a field, imported from another application, or entered in a
number of other ways.
Opening files
Important For information about opening files created in previous
versions of FileMaker Pro, see
Converting FileMaker Databases
from Previous Versions
.
To open a file if FileMaker Pro isn’t running, choose one of the
following methods:
1 Double-click the FileMaker Pro file.
1 Drag the file onto the FileMaker Pro application icon.
1 Double-click the FileMaker Pro application icon. In the New
Database dialog box, select Open an existing file, then click OK, then
double-click the filename.
To open a file if FileMaker Pro is already running:
1. Choose File menu > Open.
2. Double-click the name of the file to open.
If you’re asked for an account name and password, type them in the
Password dialog box, then click OK.
To open a file that is being shared over a network:
1. Choose File menu > Open Remote.
2. In the Open Remote File dialog box, select View for a list of hosts.
3. To see the available files from a host, select the host. In the
Available Files list, select the file you want to open.
Or, for Address, type the network path (for example,
fmnet:/hostIPaddress/fileName).
4. Click Open.
Invoices table
002Client ID
Andre CommonClient Name
818-555-1234Phone
Prod
ID Product
ET3
Price
Travel bag $29
ET4 Travel book $32
12345Invoice ID
ET3Prod ID
Travel bagProduct
$29.00Price
002Client ID
Andre Common
Name
818-555-1234Phone
Products table
C
lients table
34Stock
Choose To display
Favorite Hosts Hosts you previously added as favorites
Local Hosts FileMaker Pro hosts on your TCP/IP subnet
Hosts Listed by LDAP FileMaker Pro hosts available through the
specified LDAP server