Small and medium business | Business Central, N...

Relationship between two tables of business central

(0) Share

Report

Posted on by Inkey Solutions

2,057

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?

Thank you.

All responses (4)

Answers (0)

Suggested answer

pankaj.k 976 on at

Like (0)

Report

RE: Relationship between two tables of business central

I try to find the Record ID but its not updated for all the tables.
Inkey Solutions 2,057 on at

Like (0)

Report

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.

Thank You.
Suggested answer

pankaj.k 976 on at

Like (2)

Report

RE: Relationship between two tables of business central

Hi Inkey,

it linked with Link ID it's primary key.

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.
Suggested answer

DAnny3211 9,278 Moderator on at

Like (0)

Report

RE: Relationship between two tables of business central

Hi

the connection is as follows:

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:

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