web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Why Include DrillDownPageID and LookupPageID Properties in AL?

(3) ShareShare
ReportReport
Posted on by 30
Hello!
I’m playing with a project involving the following tables. The first table is defined like this:
 
table 50101 "Radio Show Type"
{
    //DrillDownPageId = "Radio Show Type List";
    //LookupPageId = "Radio Show Type List";

    fields
    {
        field(1; "No."; Code[20]) { }
        field(2; "Description"; Text[100]) { }
        ...
    }
}
The second table is defined like this:
table 50100 "Radio Show"
{ 
    fields
    {
        field(1; "No."; Code[20]) { }
        field(10; "Radio Show Type"; Code[20]) { TableRelation = "Radio Show Type"; }
        ...
     }
}
I read the following question and the answers on the Dynamics Community forum: DISCUSSION, but I still don't feel like I fully grasp the concept of the DrillDownPageID and LookupPageID properties and why we would want to use them.
Everything seems to be working fine without them in my example, so why would we want to include them?
What benefits do they provide, and what might not work properly if we don’t use these properties? Thanks for your help!
 

For instance, I noted that if we add the `LookupPageID` property to the "Radio Show Type" table, we can create a new type directly through the Radio Show list. How does this property relate the list page for the Radio Shows to the `LookupPageID` property in the "Radio Show Type" table? How does the `Radio Show Type List` come into all of this? How does it work?

 

 
I have the same question (0)
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,169 Super User 2026 Season 1 on at
    Great question! Even if your app works without DrillDownPageID and LookupPageID, including them adds clarity, consistency, and better UX in Business Central.
     
    ✅ Why Use DrillDownPageID and LookupPageID?
     
    1. LookupPageID
    Specifies which page opens when users use the lookup (🔍) on a field that links to your table.
     
    Example: When selecting "Radio Show Type" from "Radio Show", it opens the Radio Show Type List.
     
    Benefit: Ensures users see the right lookup page with proper filtering, layout, and actions.
     
     
    2. DrillDownPageID
    Used when a user clicks on a field with a FlowField or drill-down capability (like quantities or balances).
     
    Opens the page that lets them “drill into” that data.
     
    It’s less common for simple lookup tables but critical in financial/reporting data.
     
     
     
    ---
     
    🔍 What Happens If You Don’t Use Them?
     
    AL tries to guess the best page to use — which may work, or may not.
     
    You lose control over UI behavior, especially if users expect a specific experience.
     
    Features like page customization, navigation, or data entry flows may not work as intended.
     
     
     
    ---
     
    🔁 In Your Example:
     
    When you set:
     
    LookupPageID = "Radio Show Type List";
     
    …it lets users open a proper lookup page from the "Radio Show" table and even create new records from that list.
     
    > It connects the field to a specific page experience, rather than relying on BC’s default behavior.
     
     
     
     
    ---
     
    💡 Summary:
     
    ✅ Use LookupPageID for fields with TableRelation → better control of lookup pages.
    ✅ Use DrillDownPageID if your table is involved in FlowFields or reporting.
    🧩 They aren’t required — but skipping them is like not labeling doors in a big building: people might still get in, but it’s not great UX.
     
     
    Mark below checkbox to make this answer Verified if it helps you.
     
     
  • Suggested answer
    RockwithNav Profile Picture
    8,991 Super User 2026 Season 1 on at

    LookupPageID: Specifies the page (by ID or name) that opens when a user performs a lookup action on a field — for example, clicking the lookup arrow to select a record from a related table. It is typically used to display a list page for selecting records. For instance, setting LookupPageID to a list page like Customer List (ID 22) allows users to select a customer from that page.

     

    DrillDownPageID: Defines the page that opens when a user drills down into a field, typically a FlowField, to view the underlying transactions or data — for example, clicking the down arrow on a calculated field. This is often a list page showing the detailed records that contribute to the field's value, such as General Ledger Entries for a balance field.

     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,922 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,078 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 628 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans