How to Fix Notion Database Relation Property Not Showing Linked Records
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
- Using
foldlinstead offoldl'causing stack overflow on large lists - Forgetting
deriving (Show, Eq)on custom data types needed for debugging - 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
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