Linking two tables on a new page

(1) Share

Report

Posted on by SM-29071316-0

Hi There

I am very new to BC365 and looking for a bit of help, I have created a
new page with a source table of Contacts. I have added specific fields
from the Contacts table but I need the “No.” field from the Customer
table.

Below is what I have so far, when I edit the page I do get a
drop-down on that field that has all the Customer “No.” values but I
need it to auto-populate and link with the CT “No.” field from the
Contact table.

page 90200 "Sales-i Contact"
{
    ApplicationArea = All;
    Caption = 'Sales-i Contact';
    PageType = List;
    SourceTable = Contact;

    layout
    {
        area(Content)
        {
            repeater(General)
            {
                Caption = 'General';
                field("No Contact Business Relation"; Rec."No. of Business Relations")
                {
                }

                field("Company No"; CustomerNo."No.")
                {
                    TableRelation = Customer."No.";
                }

                field("No."; Rec."No.")
                {
                }

                field("First Name"; Rec."First Name")
                {
                }
                field("Middle Name"; Rec."Middle Name")
                {
                }
                field(Surname; Rec.Surname)
                {
                }
                field(Name; Rec.Name)
                {
                }
                field("Job Title"; Rec."Job Title")
                {
                }
                field("Phone No."; Rec."Phone No.")
                {
                }
                field("Fax No."; Rec."Fax No.")
                {
                }
                field("Mobile Phone No."; Rec."Mobile Phone No.")
                {
                }
                field("E-Mail"; Rec."E-Mail")
                {
                }
                field(Address; Rec.Address)
                {
                }
                field("Address 2"; Rec."Address 2")
                {
                }
                field(City; Rec.City)
                {
                }
                field(County; Rec.County)
                {
                }
                field("Post Code"; Rec."Post Code")
                {
                }
                field("Country/Region Code"; Rec."Country/Region Code")
                {
                }
            }
        }
    }
    var
        CustomerNo: Record Customer;

}

As I said I am very new to this and any help would be appreciated.

Thanks

Sean

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Mustafa Omerbegović 1,477 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello Sean,

I believe that you will need to use FieldClass = FlowField

That is the way to show data from different table in the desired field on another table.

On the following link you can find more information about flow fields.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfields

Greetings

Was this reply helpful? Yes No
Matteo Fiocco 260 on at

Like (1)

Report
Copy link

Link copied!

Yes, as the colleague says, the correct way is to use a calculated field (flowfield)

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

I hope this can help you and give you some hints

Dynamics 365 Business Central: FlowFields (Sum, Average, Exist, Count, Min, Max, Lookup) | Dynamics 365 Lab (yzhums.com)

FlowFields, the superpower inside Business Central. (youtube.com)

BR

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, I hope the following information can give you some help.

https://yzhums.com/22220/

Thanks.

ZHU

Was this reply helpful? Yes No
SM-29071316-0 9 on at

Like (2)

Report
Copy link

Link copied!

Hi Mustafa Omerbegović

Thank you for your reply, that has helped and is now working, I cant mark your answer as the answer when i try the page just freezes. I have tried on multiple browsers.

Thanks for your help

Was this reply helpful? Yes No
Mustafa Omerbegović 1,477 Moderator on at

Like (2)

Report
Copy link

Link copied!

You're welcome Sean, it's fine.

I am glad I could help and I wish you a lot of luck and patience.

Was this reply helpful? Yes No