Connecting Databases: Linking Related Information

1. The Power of Connection: Why Relations Are a Game-Changer

Before we dive into how to create a relation, let's understand why it's so critical. Imagine you have a database for "Projects" and another for "Tasks". Without relations, there is no way for Notion to know which tasks belong to which project. You could try to manage this manually within a single project page, but as you know from your project management experience, this quickly becomes messy and unscalable.

Relations solve this problem by creating a direct, clickable link between entries in different databases.

To see this problem and its solution in action, watch the beginning of the following video. It perfectly illustrates the limitations of a Notion setup without relations and then introduces them as the key to creating clarity and context.

As you saw, relations allow you to build systems where opening a specific project page shows you only the tasks and notes related to that project. This is the foundation of the clean, intuitive, and powerful templates that customers are willing to pay for.

2. How to Create a Relation

Creating a relation is like adding any other property to a database. The key difference is that instead of choosing a property type like Text or Date, you'll choose Relation and then specify which other database you want to connect to.

Let's stick with our classic example: connecting a Projects database to a Tasks database.

Creating a Two-Way Relation

When you link two databases, you almost always want the connection to work both ways. If you link a task to a project, you also want to see that task appear on the project's page. This is called a two-way relation (or two-way sync).

The official Notion channel provides a quick and clear demonstration of this process.

Here's a breakdown of the steps you saw in the video:

1. Add a new property to your first database (e.g., your "Tasks" database).
2. Select Relation from the property type menu.
3. Select the database you want to connect to (e.g., your "Projects" database).
4. Notion will ask if you want to show this on the other database. Toggle this ON to create the two-way relation.
5. Notion automatically creates a corresponding relation property in the second database. You can rename these properties to be more descriptive (e.g., "Project" in the Tasks DB, and "Tasks" in the Projects DB).
6. Click on a cell in the new relation column to search for and link pages from the other database.

For a detailed written guide that you can refer back to, the Notion Help Center provides the official documentation.

3. Advanced Use Case: Relating a Database to Itself

Sometimes, you need to link items within the same database. The most common use case for this is creating parent tasks and sub-tasks. One "master" task can be related to several smaller "child" tasks, all within the same Tasks database.

This is often called a self-referencing relation.

The setup is very similar, but when you select the database to relate to, you simply choose the database you are already in.

When creating a self-referencing relation to manage parent/child relationships, it's best practice to create two separate properties (e.g., "Parent Task" and "Sub-tasks") as shown in the article. This makes the relationship clear and easy to filter by.

✍️ Exercise: Build Your First Connected System

Let's put this into practice by building a mini project and task manager. This will serve as a foundational exercise for the full project we'll build in Module 5.

Part 1: Create Your Databases

• Create a new page in your workspace and name it "My First Connected System".
• On this page, create a Full-page database named Projects.
  • Add a Select property called Status with options: "Not Started", "In Progress", "Completed".
• Below the Projects database, create an Inline database named Tasks.
  • Add a Select property called Status with options: "To Do", "Doing", "Done".
  • Add a Date property called Due Date.

Part 2: Create the Relation

• In your Tasks database, add a new property.
• Name it Project and select the Relation property type.
• In the configuration menu, select your Projects database.
• Toggle Show on Projects to ON. A new property will be created in the Projects database. Let's rename it to Tasks.
• Click the blue Add relation button.

Part 3: Link Your Items

• In your Projects database, add two projects: "Design New Website" and "Launch Q3 Marketing Campaign".
• In your Tasks database, add three tasks: "Draft homepage wireframe", "Create social media graphics", and "Write campaign announcement email".
• Now, link them! In the Tasks database, click inside the Project cell for "Draft homepage wireframe" and select the "Design New Website" project.
• Link the other two tasks to the "Launch Q3 Marketing Campaign" project.
• Verify the connection: Open the "Design New Website" page from your Projects database. You should now see "Draft homepage wireframe" listed under the Tasks property. Success!

Lesson Summary and Next Steps

Fantastic work! You have just unlocked the single most important feature for building advanced Notion systems. By linking databases, you've taken the first step toward creating an interconnected workspace where information is organized, contextual, and easy to navigate.

Key Takeaways:

• The Relation property is the "glue" that connects entries between databases.
• Two-way relations are crucial for creating a connection that is visible and accessible from both databases involved.
• You can create a self-referencing relation to link items within the same database, such as for parent tasks and sub-tasks.
• This feature is the core building block for almost every professional Notion template, from project managers to content calendars.

Now that we can link information, a new question arises: how can we use the information from a related page? For example, how can we see the completion status of all tasks related to a project directly on the project's page?

That is the job of our next topic: Rollups. In the next lesson, you'll learn how to use rollups to pull in and aggregate data from related database entries, allowing you to perform calculations and create powerful summary views.