asking for code

(1) Share

Report

Posted on by dsnel

I am new to Business Central. I want to retrieve record using primary key from another table. I have customer table and want to fetch details from item table. I have given table relation, using current record other fields should appear. Can anyone help me with the code ?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

keoma 32,729 on at

Like (0)

Report
Copy link

Link copied!

here is a sample code:

pageextension 50100 CustomerListExt extends "Customer List"

{

layout

{

addlast(Control1)

{

field(itemNo; item."No.") { }

field(itemDesc; item.Description) { }

}

}

trigger OnAfterGetRecord()

begin

//sample item filter

item.SetRange("Country/Region of Origin Code", "Country/Region Code");

if item.FindFirst() then;

end;

var

item: record item;

}

Was this reply helpful? Yes No