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

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

Teddy
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.

Author: Teddy

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.

Share This Post On