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 🤝
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.
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