Adding a Related Table

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Tables and Forms > System Tables (ST) >

Adding a Related Table

In EQuIS Professional, when opening tables, users may add related tables (parent and/or child tables) to determine relationships between tables and better evaluate data. Examples of how to perform the steps necessary to add tables are listed below.

 

Adding Related Tables - Data Tables

 

1.Open DT_SAMPLE using the default options.

2.Click in the blank space at the beginning of a row in DT_SAMPLE so that a black triangle appears 15009-SelectedRowArrow, and then right-click in this space.

3.Select Related Tables > Child Tables > DT_TEST.

4.Expand the node that appears to the left of the rows in DT_SAMPLE, and the related rows in DT_TEST will appear.

5.Repeat step 3 in the blank space area of the related rows from DT_TEST the process to but add DT_RESULT.

6.Continue by Pinning and Filtering your data.

 

The result of this exercise will show the related tables linked together at the bottom of the Tabular View of tables as shown in the image below.

 

15009-MultipleTablesNestedAddRecords1

                           Related Data Tables

 

Adding Related Tables - Reference Tables

 

1.Open RT_MTH_ANL_GROUP.

2.Click in the blank space at the beginning of a row in RT_MTH_ANL_GROUP so that a black triangle appears 15009-SelectedRowArrow, and then right-click in this space.

3.Select Related Tables > Child Tables > RT_MTH_ANL_MEMBER.

4.Expand the node that appears to the left of the rows in RT_MTH_ANL_GROUP. The related rows in RT_MTH_ANL_GROUP will appear.

 

The result of this exercise will show the related tables linked together at the bottom of the Tabular View of tables as shown in the image below.

 

15009-MultipleTablesNestedAddRecords2

                              Related Reference Tables

 

Removing Related Tables

 

Child or parent tables can now be removed by selecting the table once more from the relation menu. Once removed, the user will be able to open that child or parent table separately and edit it. Users will not be able to reopen the child or parent tables to the previous table, unless they remove the table they were adding relations to from the workspace, and reopen it.