Database Structure and Program Structure

Relations between files are defined in the database. The Database Structure-Program Structure form displays a picture of the relations the primary file has with other files in the product line. This is the database structure of the primary file.

The first layer of the database structure shows the primary file. The second layer shows the files with a one-to-one relation from the primary file. The third layer shows the files with a one-to-many relation from the primary file.

Below the database structure, the system displays the file structure of the program, called the program structure. The first layer of the program structure shows the primary file. If a program has several tasks, the first layer shows the primary file for each task. The second layer of the program structure shows any detail files defined for a task, under its primary file.

The database structure displaying is for the selected task. You select a task using the right and left arrow keys.

In the following example, the program has one task. The primary file for the task is Company. This task also accesses a detail file, Departments. (For more information, see Defining a Detail file.)

The database structure shown in the example is for the Company file. If you select Department, the form displays the database structure for the Department file.