Progress
Results User’s Guide
for Windows
Table Relationships
The most powerful advantage that a database has over a paper filing system is that it can process data based on the relationship between database tables. The relationship is based on shared data. As shown in Figure 1–6, the Customer record contains the customer number, name, and address fields. The Order record contains the customer number, order number, delivery date, etc. The Order table is related to the Customer table because they contain a common field: Customer No.
Figure 1–6: Relationship Between Customer and Order Tables
![]()
With relationships between the Customer and Order tables established, you can perform requests for information, called queries. For example, you can query the database to find:
As you can see by the relationship between the Customer and Order tables, relationships between tables are based on standard business practices. These relationships are determined when the database is designed.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |