There are multiple ways in BC to create a Lookup button for a variable in a page or report. Generally speaking, I have seen three following methods being done to achieve the lookup button.
1. Using Table Relation
field(fieldItemCode1; ItemCode)
{
ApplicationArea = All;
Caption = 'Item Code 1';
TableRelation = Item."No.";
trigger OnValidate()
begin
...Continue Reading thatnavguy’s Article on their blog
Page OnLookup Trigger
There are multiple ways in BC to create a Lookup button for a variable in a page or report. Generally speaking, I have seen three following methods being done to achieve the lookup button. 1. Using Table Relation field(fieldItemCode1; ItemCode) { ApplicationArea = All; Caption = ‘Item Code 1’; TableRelation = Item.”No.”; trigger OnValidate() begin…
Blog Syndicated with thatnavguy’s Permission
More About This Author
-
Experienced NZ-based NAV Developer and Consultant with 10+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central.
I have led multiple Dynamics NAV and Business Central projects for businesses in Asia, such as Japan, Singapore, and Indonesia, and currently in both Australia and New Zealand.
I am passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs. I believe in adding value to people’s lives and try to leave people better than when I first met them.
Array
Business Central7 March 2023D365 Business Central : An environment with the same name already exists
Business Central3 March 2023D365 Business Central : Enable Job Queue in Docker Container
Business Central1 February 2023D365 Business Central : Suggest Account on General Posting Setup- Business Central26 January 2023D365 Business Central : Persistent Blob
