Progress
Language Tutorial
for Character


Relating Records

Imagine that a sales manager at All Around Sports discovers that a shipment of a best-selling product is a month late from the manufacturer and may be delayed for another three weeks. The sales manager wants to write to the affected customers about the delay. All Around Sports asks you to come up with a quick computer solution. You decide to write a procedure to generate a letter for each customer. However, the information you need for this project is in different tables. You need to:

In a paper system, finding related data in different tables would be a tedious manual task. In some databases, you’d also have a hard time accomplishing this task. You need to use a relational database to put together data from related files, and you’ve got one with Progress. This process is also called joining tables or creating a join. For more information on joins, see the section on inner and outer joins later in this chapter.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095