User manual

Chapter 4 | Working with related tables and files 89
Single-criteria relationships
In a single-criteria relationship, data in one field is matched to data in another field.
For example, a record in either table is related to any record in the other table when the values
TextFieldA and TextFieldB are the same.
Use a single-criteria relationship to relate two tables based on a single common value, such as a
serial number or an ID number. For example, a database has two tables: Customers, which stores
names and addresses, and Contacts, which stores phone numbers, types of phone numbers
(such as work, home, fax, and so on), and email addresses. The data is split between two tables
because a single customer can have multiple phone numbers and email addresses.
The tables have the following fields:
The Customer ID field is the match field in the relationship between the two tables. In the
Customers table, the Customer ID field is set to auto-enter a serial number, giving each record in
the Customers table a unique ID number. In the Contacts table, the Customer ID is a simple
number field.
Table Field name Comment
Customers Customer ID Number field, auto-enter serial number; this will be the match
field in the Customers table
First Name Text field
Last Name Text field
Address1 Text field
City Text field
State Text field
Country Text field
Contacts Phone Number Text field
Phone Type Text field
Email Address Text field
Email Type Text field
Customer ID Number field; this will be the match field in the Contacts table
Match field
Match field