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
- Working with data in Table View
- Finding records
- Performing quick finds in Browse mode
- Making find requests in Find mode
- 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
- Viewing, repeating, or changing the last find
- Saving find requests
- Deleting and reverting requests
- 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
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- 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
- Creating and editing charts
- 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
- Setting up recurring imports
- 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
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Converting databases from FileMaker Pro 11 and earlier
- Index
Chapter 4 | Working with related tables and files 106
Multi-criteria relationships
In a multi-criteria relationship, you increase the number of match fields, which increases the
criteria that FileMaker
Pro evaluates before successfully joining related records. In a multi-criteria
relationship, FileMaker
Pro compares the values from each match field on each side of the
relationship in the order in which the fields appear. This is called an AND comparison; to match
successfully, every match field must find a corresponding value in the other table.
In this relationship, both TextFieldA and NumberFieldA are match fields to TableB. A record in
TableA with a TextFieldA value of Blue and a NumberFieldA value of 123 will only match those
records in TableB where both TextFieldB and NumberFieldB have values of Blue and 123,
respectively. If TextFieldA and TextFieldB have matching values, but NumberFieldA and
NumberFieldB do not, no related records are returned by the relationship.
Use a multi-criteria relationship when you want to relate two tables based on more than one
common value, such as a customer ID and a date.
For example, a catering equipment rental database has three tables: Equipment, a static table that
stores equipment rental inventory; Customers, which stores customer names and addresses; and
Catering Line Items, which stores a record of each equipment rental, including the equipment ID,
the customer ID, and the event date. The purpose of this database is to track equipment rentals
and display all rentals by a selected customer on a selected date.
In this relationship, both Customer ID and Event Date are match fields to the Catering Line Items
table. A record in the Customers table with a Customer ID value of 1000 and a Event Date value
of 10/10/2014 will only match those records in the Catering Line Items table where both fields
Customer ID and Event Date have values of 1000 and 10/10/2014, respectively. If Customer ID
fields in both tables have matching values, but Event Date fields in both tables do not, no related
records are returned by the relationship.
Although the database uses three tables, the multi-criteria relationship is between the Customers
and Catering Line Items tables. These tables have the following fields:
Table Field name Comment
Customers Customer ID Number field, auto-enter serial number; one of the match fields to the
Catering Line Items table
Event Date Date field; the other match field to the Catering Line Items table
Match field Match field
Match fields
Match fields