When you connect databases in Notion, you can create a relation that links entries from one database to another. However, Notion offers two types of relations: one-way and two-way. A one-way relation displays linked entries only in the source database, while a two-way relation creates a reciprocal connection in the target database. This article explains the difference between these two relation types and provides clear guidance on when to use each. You will learn how to set up both types and avoid common mistakes that break your data structure.
Key Takeaways: Choosing Between One-Way and Two-Way Relations in Notion
- One-way relation: Links entries from the source database only; the target database shows no reciprocal column. Use when only one side needs to see the connection.
- Two-way relation: Creates a mirrored relation column in both databases. Use when both databases must display and filter linked entries.
- Rollup property: Works with any relation type but pulls data from the linked entry. Requires a relation column to exist in the same database.
What Is a Notion Relation and How Does It Work?
A relation in Notion is a database property that connects an entry in one database to one or more entries in another database. For example, you can link a Tasks database to a Projects database so that each task is associated with a specific project. The relation column stores the linked entry ID and displays the linked page title or a preview.
When you create a relation, Notion asks you to choose a name for the relation column in the current database and a name for the reciprocal column in the target database. If you keep the reciprocal column name, Notion creates a two-way relation. If you delete the reciprocal column name during setup, you get a one-way relation.
A one-way relation appears only in the source database. The target database has no column showing which entries link back. A two-way relation adds a column to both databases, allowing you to see and edit connections from either side. Both relation types support linking multiple entries using the multi-select interface.
Prerequisites for Creating a Relation
Before you create a relation, you need two existing databases in the same Notion workspace. Both databases must have at least one page or entry. The relation property does not require any specific permissions or plan tier. Free, Plus, Business, and Enterprise plans all support relations with no limit on the number of relations per database.
Steps to Create a One-Way Relation in Notion
Follow these steps to create a relation that links entries from one database to another without adding a reciprocal column in the target database.
- Open the source database
Navigate to the database where you want the relation column to appear. This is the database that will display the linked entries. - Add a new property
Click the plus sign (+) in the database header where properties are listed. A dropdown menu appears. - Select Relation from the property list
Scroll down in the property type menu and click Relation. A setup dialog opens. - Choose the target database
In the dialog, click the dropdown under Connect to and select the database you want to link to. For example, if you are linking tasks to projects, select the Projects database. - Remove the reciprocal column name
Below the target database selection, you see a field labeled Relation name in [target database]. Delete the text in this field so it is empty. Leaving this field empty tells Notion to create a one-way relation. - Click Create Relation
Confirm the setup. The new relation column appears in your source database. No column is added to the target database.
After creating the one-way relation, you can click any cell in the new column and select entries from the target database. The linked entries display as page links in the source database only.
Steps to Create a Two-Way Relation in Notion
A two-way relation adds a reciprocal column in the target database. Use this method when both databases need to show the connection.
- Open the source database
Go to the database where you want the initial relation column. - Add a new property and select Relation
Click the plus sign (+) in the property header, then choose Relation from the list. - Select the target database
In the setup dialog, pick the database you want to connect from the Connect to dropdown. - Keep the reciprocal column name
Below the target database selection, you see the field Relation name in [target database]. Leave the default name or type a custom name. Notion creates a relation column with this name in the target database. - Click Create Relation
Confirm the setup. Now both databases have a relation column. Adding a link in one database automatically adds a reciprocal link in the other database.
When you link an entry in the source database to an entry in the target database, the target entry automatically shows the source entry in its reciprocal column. You can also add links from the target side, and the source side updates automatically.
Common Mistakes and Limitations
Accidentally Creating a Two-Way Relation When You Need One-Way
If you leave the reciprocal column name filled in during setup, Notion creates a two-way relation. To convert an existing two-way relation to one-way, you must delete the relation column from one database. Right-click the relation column header in the target database and choose Delete property. This removes the reciprocal column but keeps the original relation intact. However, any links already created remain visible only from the source side.
Two-Way Relation Causes Unwanted Clutter in Target Database
A two-way relation adds a column to every entry in the target database. If the target database has many entries and you only need the link from one side, the extra column may clutter the view. In this case, use a one-way relation to keep the target database clean.
Rollup Property Does Not Work Without a Relation
A rollup property pulls data from a linked entry through a relation. If you delete the relation column that a rollup depends on, the rollup breaks and shows an error. Always check which rollup properties reference a relation before deleting it.
Cannot Create a Relation Between Databases in Different Workspaces
Notion relations only work between databases inside the same workspace. You cannot link databases from two separate workspaces. To connect data across workspaces, use linked databases or duplicate the data into one workspace.
One-Way vs Two-Way Relation: Comparison
| Item | One-Way Relation | Two-Way Relation |
|---|---|---|
| Reciprocal column | Not created in target database | Created automatically in target database |
| Visibility of links | Visible only in source database | Visible in both source and target databases |
| Editing links | Only from source database | From either database |
| Use case | Simple lookup or reference without backlink | Bidirectional tracking like project-task mapping |
| Database clutter | No extra column in target | Adds a column to every entry in target |
| Setup complexity | Requires removing reciprocal name | Default setup with no extra action |
Now you can decide which relation type fits your workflow. Use a one-way relation when you only need to look up data from a single database, such as attaching a client name to an invoice without showing invoices in the client database. Use a two-way relation when both databases need to display and filter linked entries, such as linking tasks to projects where each project page lists all its tasks. To convert between types later, delete the relation column from the database you want to remove, but remember that rollup properties referencing that column will break.