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

Display a specific preview TableRelation page

(0) ShareShare
ReportReport
Posted on by 50

Hi all,

My situation is the following:

- I have created a table named "Material" and the corresponding Card and List pages.

- I have extended the Item table to include this Material field.

- I have created an Item list page with only two fields ("No." and "My Description") and I want that page as my lookup.

I want to assign a default Item to a certain Material, so in the Material Card Page I have:

            field("Default Sheet"; "Default Sheet")
            {
                ApplicationArea = All;
                Tooltip = 'The Default Sheet is used to calculate the standard cost and will be carried out automatically to sheet part manufacturing';
                LookupPageId = "Item Specific Lookup";
                TableRelation = "Item" where("Material" = field("No.");
            }
And when clicking on the Lookup I get the following. The preview page shows the page "Item Look Up", that is the page defined in the Item table in LookUpPageId.
pastedimage1584465266946v1.png
If I click on "Select from full list" my "Item Specific Lookup" page is displayed. But I also want that page to be displayed in this preview because I need to see those two fields. 
Is this possible?
I have worked a workaround using the trigger OnLookUp but that forces me display a Modal page and I would like to avoid that.
            field("Default Sheet"; "Default Sheet")
            {
                ApplicationArea = All;
                Lookup = true;

                trigger OnValidate()
                begin
                    CurrPage.Update();
                end;

                trigger OnLookup(var Text: Text): Boolean
                var
                    Item: Record "Item";
                begin
                    Item.SetRange("Material", "No.");
                    if Item.FindSet() then
                        if PAGE.RunModal(PAGE::"Item Specific Lookup" , Item) = ACTION::LookupOK then "Default Sheet" := Item."No.";
                    CurrPage.Update();
                end;
            }
Best regards,
I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Microsoft Employee on at

    Hello Sergio - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist.  If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,822 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,136 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 956 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans