Have you ever wanted to connect the data between two tables? You're in luck! Notion's relation property is designed to help you express useful relationships between items in different databases 🤝

https://youtu.be/NM8oFVb8SAY

What is a database relation?

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 below, the columns labeled ↗ Items 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.

Customers

Items

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