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

Relationship between two tables of business central

(0) ShareShare
ReportReport
Posted on by 2,086

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,376 on at
    RE: Relationship between two tables of business central

    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
    994 on at
    RE: Relationship between two tables of business central

    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,086 on at
    RE: Relationship between two tables of business central

    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
    994 on at
    RE: Relationship between two tables of business central

    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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,285

#2
Sumit Singh Profile Picture

Sumit Singh 2,725

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans