Creating Database Table Relationships
  • 11 Feb 2022
  • 1 Minute to read
  • Dark
    Light

Creating Database Table Relationships

  • Dark
    Light

Overview

The purpose of creating a Database Table Relationship is to integrate data from two separate database tables and pull from them at the same time. 

Example

This example demonstrates how to display columns from related Tables in the Report Designer. This is done by creating a Relationship between Tables to join them. Then, this Relationship can be used in the Report Designer to add a related Data Source.

  1. Start by creating a Relationship between Tables. In the designer Folders Navigate to System > Integrations > Databases folder in the Portal. Next, navigate to the Database Folder to create a Relationship. From the Folder Actions Panel, select Add Relationship.
  2. In the Add Relationship resulting window give a Name to the Relationship. Then, pick Tables and Fields that should be Related. Click Ok when finished.

  3. Next, navigate to a Designer Project Folder and click Create Page/Report > Create Report from the Folder Actions Panel and give the Report a name.

  4. In the Report Designer we expand Data Sources > Common > [Folder For Our Database] and add one of the Tables from our Relationship as Data Source.


  5. Because a relationship has been created, an option will appear called Add related table. Select Add and then select Add related table and the second table will be added to the report. 



Was this article helpful?