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

Relationship between two tables of business central

(0) ShareShare
ReportReport
Posted on by 2,116

Hi All,

I am talking about the Sales Invoice Posted Page and their Attachment section.

As you can see in the screen print, there are record-wise different links, in some records, only one link is attached and, in some records, there are two or more attachments, so I want to know, is there any relationship between these two tables? Can anyone share the column name with us?

pastedimage1670568782949v1.png

pastedimage1670569123696v2.png

pastedimage1670569522540v3.png

Thank you.

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    11,421 Super User 2026 Season 1 on at

    Hi

    the connection is as follows:

    pastedimage1670574575552v1.png

    the record id is a field type that expresses the primary key of the main record, in this case the primary key of the Sales Invoice Posted table in this way:

    pastedimage1670574834049v2.png

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods/devenv-recordid-method-record

    check my answer if it helped you, thanks

    DAniele

  • Suggested answer
    pankaj.k Profile Picture
    1,020 on at

    Hi Inkey,

    it linked with Link ID  it's primary key.

    Link.PNG

    Please find the all field and table detail...

    table 2000000068 "Record Link"
    {
        Caption = 'Record Link';
        DataPerCompany = false;
        ReplicateData = false;
        Scope = Cloud;

        fields
        {
            field(1; "Link ID"; Integer)
            {
                AutoIncrement = true;
                Caption = 'Link ID';
            }
            field(2; "Record ID"; RecordID)
            {
                Caption = 'Record ID';
            }
            field(3; URL1; Text[2048])
            {
                Caption = 'URL1';
            }
            field(4; URL2; Text[250])
            {
                Caption = 'URL2';
                ObsoleteReason = 'URL1 field size increased';
                ObsoleteState = Removed;
            }
            field(5; URL3; Text[250])
            {
                Caption = 'URL3';
                ObsoleteReason = 'URL1 field size increased';
                ObsoleteState = Removed;
            }
            field(6; URL4; Text[250])
            {
                Caption = 'URL4';
                ObsoleteReason = 'URL1 field size increased';
                ObsoleteState = Removed;
            }
            field(7; Description; Text[250])
            {
                Caption = 'Description';
            }
            field(8; Type; Option)
            {
                Caption = 'Type';
                OptionCaption = 'Link,Note';
                OptionMembers = Link,Note;
            }
            field(9; Note; BLOB)
            {
                Caption = 'Note';
                SubType = Memo;
            }
            field(10; Created; DateTime)
            {
                Caption = 'Created';
            }
            field(11; "User ID"; Text[132])
            {
                Caption = 'User ID';
            }
            field(12; Company; Text[30])
            {
                Caption = 'Company';
                TableRelation = Company.Name;
            }
            field(13; Notify; Boolean)
            {
                Caption = 'Notify';
            }
            field(14; "To User ID"; Text[132])
            {
                Caption = 'To User ID';
            }
        }

        keys
        {
            key(Key1; "Link ID")
            {
                Clustered = true;
            }
            key(Key2; "Record ID")
            {
            }
            key(Key3; Company, "Record ID")
            {
            }
        }

        fieldgroups
        {
        }
    }


    Thanks,

    Click on Yes button if my answer helped you.

  • Inkey Solutions Profile Picture
    2,116 on at

    Hi

    Thank you for the prompt reply,

    Can you tell us, how we can show a particular record Id? because I cannot see in table.

    pastedimage1670587617935v1.png

    Thank You.

  • Suggested answer
    pankaj.k Profile Picture
    1,020 on at

    I try to find the Record ID but its not updated for all the tables.

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 April 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,872 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,110 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 892

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans