User manual
Table Of Contents
- Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using FileMaker Pro
- About fields and records
- Opening and closing files
- Opening multiple windows per file
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Sorting records
- Previewing and printing files
- Backing up files
- Setting preferences
- Chapter 3 Designing and creating solutions
- Planning a solution
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- Working with layout object, part, and background styles
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with layout parts
- Creating and editing charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing data
- Sharing databases on a network
- Importing and exporting 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 solutions on the web
- Chapter 6 Protecting files
- 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 Using FileMaker Pro Advanced
- Index
Chapter 4 | Working with related tables and files 91
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:
Because the relationship is defined to allow the creation of related records in the Catering Line
Items table, you will be able to enter catering information in an empty portal row, and
FileMaker
Pro will automatically create a related record for that catered event.
Relationships using comparative operators
In a comparative relationship, you use one or more of the following operators to compare match
field values in the two related tables. The relationship returns related records when the
comparison evaluates successfully, according to the criteria you establish.
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
Catering Line Items Customer ID Number field; one of the match fields to the Customers table
Event Date Date field; the other match field to the Customers table
Equipment ID Number field
Relational
operator Matches these records
= Values in match fields are equal
≠ Values in match fields are unequal
< Values in the left match field are less than values in the right match field
≤ Values in the left match field are less than or equal to values in the right match field
> Values in the left match field are greater than values in the right match field
Match fields
Match fields
Select to allow creation of related
records in Catering Line Items table