Relationship

A well-defined relationship between database tables can easily store relational databases

To combine data from multiple tables, a relationship requires a primary key in one of the datasets.

1. Select the database containing tables you want to join

2. Hold the field from one table and drag them to the other field from another table to build a connection line between them. You can build multiple lines from different tables and many connections from one source field.

3. After creating the relationship, you can hide the table or collapse the table to show only connected fields.

4. Click on the connection line and click Remove Relationship to remove the relationship between two connected fields.

5. After creating relationships, click Save to save the progress.