Screen Shot 2018-06-20 at 3.04.50 PM
The relations editor is how you can explicitly call relations between two tables from your relational database. When you import your database, all of the foreign keys are imported into this menu. Above is listed all of the foreign keys imported from the Chinook Database. Just like the band editor, the manual addition only shows the tables inside your report by default in the two drop downs. This can be changed by deselecting the checkbox at the top of the window. To create a manual relation, just select the two tables that you want to relate, and then the two fields that share the same value for fields that should be related. You can also manually delete relations in the lower fields with the "Delete" button. Any changes done, including relationship deletions, can be undone by clicking "Cancel".