Drilldown to a specific record

(0) Share

Report

Posted on by 1239875612039

BC Experts,

I'm attempting to build out a module where we track profitability of "projects", which include multiple purchase orders and sales orders. I am building it similar to how sales headers and sales lines work, with a "Project" Table and a "ProjectLines" table.

The "Project" table has a page of type List, where I can see the project number, salesperson, customer #, etc.. I have the "ProjectNumber" field set with DrillDownPageID property set to my "ProjectCard" Page. However, when I have multiple projects, clicking on any drilldown field will always lead me to the first record of that type!

For example below, clicking the projectnumber "100456" still leads me to the card page for the "100123" project number. Please see below for my project page Code as well as a screenshot.

page 50102 Projects
{
    PageType = List;
    ApplicationArea = All;
    UsageCategory = Lists;
    SourceTable = projecttable;

    layout
    {
        area(Content)
        {
            repeater(General)
            {
                field(ProjectNumber1; Rec.ProjectNumber)
                {
                    ApplicationArea = All;
                    DrillDownPageId = projectcard;
                }
            } //multiple fields are defined below and removed for clarity
        }
    }
}

Any advice is appreciated; I suspect I'm not setting a filter correctly but have been unable to find good tutorials outside of official documentation and Erik Hougaard's videos.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

I'm sorry for any confusion what do you mean by building it similar to what we have in the sales header and lines? the best practice is to create a list page and a card page for any datasource.. the list page displays a list of records, and when you select a record, it takes you to the corresponding card page in that case, you don't need to add a specific "drill down" property you can simply use the same data source for both the list page and the card page..

Was this reply helpful? Yes No
1239875612039 15 on at

Like (0)

Report
Govinda,

Thanks for your response! I have a list page and card page for my "ProjectsTable" Table. They are both utilizing the source table of "ProjectTable". However, if I remove the "DrilldownpageID" from the projectlist page, I cannot click on the Project number to bring me onto the card view.

Here is a snippet of my List Page

page 50102 Projects { PageType = List; ApplicationArea = All; UsageCategory = Lists; SourceTable = projecttable; layout { area(Content) { repeater(General) { field(ProjectNumber; Rec.ProjectNumber) { ApplicationArea = All; //This is where my DrillDownpageID used to be } //there are more fields after this not shown here } } } }

And here is my Project Card Page

page 50100 ProjectCard { Caption = 'Billing Lead Sheet'; PageType = Card; ApplicationArea = All; UsageCategory = Documents; SourceTable = projecttable; Editable = true; layout { area(Content) { group("General Information") { field(ProjectNumber; Rec.ProjectNumber) { ApplicationArea = All; } //more fields exist that are not shown } } } }

Snippet (I cannot click on "100123" or "100456"):

Please let me know what I'm doing wrong..

Thanks!

Was this reply helpful? Yes No
Verified answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report
Try adding card page id in your list page..
page 50102 Projects { PageType = List; ApplicationArea = All; UsageCategory = Lists; SourceTable = projecttable; CardPageId = ProjectCard; layout { area(Content) { repeater(General) { field(ProjectNumber; Rec.ProjectNumber) { ApplicationArea = All; //This is where my DrillDownpageID used to be } //there are more fields after this not shown here } } } } page 50100 ProjectCard { Caption = 'Billing Lead Sheet'; PageType = Card; ApplicationArea = All; UsageCategory = Documents; SourceTable = projecttable; Editable = true; layout { area(Content) { group("General Information") { field(ProjectNumber; Rec.ProjectNumber) { ApplicationArea = All; } //more fields exist that are not shown } } } }

Was this reply helpful? Yes No
1239875612039 15 on at

Like (0)

Report

I cannot believe it was so simple; thank you!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Drilldown to a specific record

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Drilldown to a specific record

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates