Adding Tables in Data Sources

To add a table, either drag it to the “Diagram” pane or double-click on it:

Then select the required columns:

Note that if at least one table has been added to the “Diagram” pane, the “Tables” pane highlights tables that have a relationship with any of the recently added tables:

To join the already added table with an another table, do one of the following:

• either click the  button next to the foreign key column (“ProductSubcategoryKey” in the image above);
• or drag and drop the highlighted table from the “Table” pane to “Diagram”

After that, “Query Builder” displays a relationship between tables:

If necessary, the relation between the tables can be edited. To do this, right-click on the required relation and select “Edit Relation” from the context menu:

As a result, the following window appears:

The following types of relation are available in the drop-down list:

Next, in the drop-down list, select the name for the data binding:

If necessary, you can delete the relationship with the table or set a reverse relationship: