1. Click on a table name on the ‘Tables’ index page. Along the right side you will see an option for ‘Relationships’.
2. By clicking ‘New’, you will be shown a pop-up box. In this pop-up box, the 1st drop-down is the column from your current table, the 2nd drop-down is the other relational table you want to establish a connection with, and the 3rd drop-down is the column from the other relational table.
3. You can add as many relationships as you wish between multiple relational tables. E.g. If you have 3 separate tables (contact’s info, purchase info, and product details), you can establish relationships to connect all 3 tables to be able to pull and utilize the data within.
4. By choosing which columns that will bridge the relational tables together, you now have a link between two or more tables.