We use relations extensively in our systems to help us build structured data.

Let's say you have two databases for your theoretical business 😉

• One that tracks customers
• One that tracks items purchased

You want to know both which customers bought which items, as well as which items were purchased by which customers. This is a job for relations!

• In the two tables above, the columns labeled ↗ Items Purchased and ↗ Customers are relation properties, which can be added like any other database property.
• Here, when you add an item bought into the Customers database, the customers who bought them automatically appear in the ↗ Customers column in the Items database.

Example use cases

• Connect your database of restaurants with your database of neighborhoods so you can see which restaurants are in which neighborhoods at a glance.
• Connect your database of meeting notes with your database of clients to provide quick access to the notes relevant to each client.
• Connect your database of tasks with your database of bigger projects to understand how projects are broken down into tasks, and how tasks contribute to projects.
• Connect your database of candidates with your database of interviewers to keep track of who interviewed whom.

Create a relation

To relate two databases, you need two databases. So let's assume you've made the Customers and Items databases above for the purpose of this walkthrough.

• Add a new column/property to your Customers database.
• In the property menu, give it a name in the box provided, like Items Purchased.
• Choose Relation from the Type menu.