web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 26
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
    RockwithNav Profile Picture
    8,129 Super User 2025 Season 2 on at
    Why Include DrillDownPageID and LookupPageID Properties in AL?

    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.

     
     
     
  • Suggested answer
    Sohail Ahmed Profile Picture
    11,009 Super User 2025 Season 2 on at
    Why Include DrillDownPageID and LookupPageID Properties in AL?
    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.
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 3,055

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,209 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans