Generating auto-relationships

You can automatically generate new relationships between tables in a data module. The tables can be located in different sources.

This feature has the following benefits:
  • Reduces the effort that is required to identify related tables and establish connections between them when creating relationships manually.
  • Reveals relationships that users might not have originally considered.
  • Enhances the overall efficiency and depth of relationship discovery.

Procedure

  1. In the Relationships diagram or the data tree, select one or multiple tables, and from their context menu, click Auto-relationships.
    • If you initiate auto-relationships for one table, when the relationship discovery is successfully completed, the toast message shows the number of generated relationships, and the new relationships are visible in the relationship diagram.
    • If you initiate auto-relationships for two or more tables, a dialog box is displayed where you can select or clear the Include other tables in the data module checkbox to limit the discovery of relationships to the tables that you selected or include all tables in the data module (default). Then, click Generate.

      After the discovery is successfully completed, the toast message shows the number of generated relationships, and the new relationships are visible in the relationship diagram.

    Tip: You can use the undo Icon to undo an action and redo Icon to redo an action. buttons in the application bar to revert or restore your changes.
  2. Save the data module.