Skip to content

How to Fix Notion Database Relation Property Not Showing Linked Records

DodaTech Updated 2026-06-24 3 min read

In this tutorial, you'll learn about How to Fix Notion Database Relation Property Not Showing Linked Records. We cover key concepts, practical examples, and best practices.

Notion database relation properties create connections between two databases. When a relation property shows no linked records, the relation is configured with the wrong database, the linked record was deleted, or the relation filters are too restrictive.

The Problem

You create a relation property in Database A that links to Database B, but the relation cell shows "No items" or "Select a page" even though Database B has pages.

Wrong approach — recreating the entire relation property.

The Fix

Verify the target database is correct:

1. Open the database → click the "..." menu → Properties
2. Find the relation property → click "Edit property"
3. Check "Connected database" — ensure it points to the correct database
4. If wrong, change it to the correct database

Check if the relation is populated:

1. Click inside the relation cell in a database row
2. A dropdown should show available pages from the target database
3. If the dropdown is empty, the target database has no pages
4. Create a page in the target database first

For relation values not showing after linking:

1. Click the relation cell
2. Search for the target page by name
3. Select it → relation is established
4. The name of the linked page appears in the cell

Expected output:

Relation cell shows linked page names from the target database
Dropdown lists all available pages for linking
Multiple pages can be linked (unless "Limit to one" is enabled)

Prevention Tips

  • Create pages in the target database before setting up relations
  • Name pages clearly so they are easily searchable in relation dropdowns
  • Enable "Show on [target] database" to create a bi-directional relation
  • Use rollup properties to display data from related pages
  • Check relation filters if some target pages are not appearing

Common Mistakes with database relation

  1. Using foldl instead of foldl' causing stack overflow on large lists
  2. Forgetting deriving (Show, Eq) on custom data types needed for debugging
  3. Placing the wildcard pattern first in case expressions, making all subsequent patterns unreachable

These mistakes appear frequently in real-world NOTION code. DodaTech's contributors have identified these patterns through analysis of open-source projects and production systems.

Practice Exercise

Write a pure function that safely divides two integers using Maybe, then test it with edge cases like division by zero and negative numbers.

This exercise reinforces the concepts covered in this guide. Try implementing it before checking online solutions.

FAQ

### How do I create a bi-directional relation in Notion?

When creating the relation, enable "Show on [database name]" — this creates a relation property in the connected database that automatically mirrors links. Linking a page in one database automatically links it back in the other database.

Why are some pages missing from the relation dropdown?

The relation dropdown shows all pages in the connected database. If pages are missing, check if they are in a different database view with filters. The relation itself is not filtered — all pages in the target database should appear.

Can I relate a page to itself or to pages in the same database?

Yes, select the same database as both "Current database" and "Connected database" when creating the relation. This creates a self-referencing relation, useful for hierarchies or task dependencies within the same database.

Related: DodaTech's Database Relation Mapper visualizes all connections between Notion databases, identifies orphaned relations, and suggests schema improvements for linked data. Use with DodaZIP for backup.

Built by the developers of DodaTech

Doda Browser, DodaZIP & Durga Antivirus Pro