OnAfterLookup (Page Field) trigger
Version: Available or changed with runtime version 7.0.
Runs after a lookup is activated passing the selected record as a RecordRef.
Syntax
trigger OnAfterLookup(Selected: RecordRef)
begin
...
end;
Parameters
Selected
Type: RecordRef
The selected record.
Remarks
This trigger is introduced with runtime 7.0 of AL to address issues that arise when in Business Central, for example, more items have the same Description. With former solutions, the lookup mechanism would find the selected record based on the filtering in the lookup dialog. This made it impossible to predict which record the user had selected.
Note
If you have defined an OnLookup Trigger, the OnAfterLookup Trigger will not be fired.
Example
The following is a simplified example of how the OnAfterLookup trigger can be used. The No. and Description fields point to fields in the Item table and should be updated at the same time, even if only one of the fields is available in a dropdown; the corresponding field must also be set. No. is the primary key and unique, but there could be more records in the Item table with the same Description. The OnAfterLookup trigger looks up the chosen record and returns it in a RecordRef.
table 37 "Sales Line"
{
// Skipped
fields
{
// Skipped
field(6; "No."; Code[20])
{
TableRelation = Item;
}
field(11; Description; Text[100])
{
TableRelation = Item.Description;
ValidateTableRelation = false;
}
// Skipped
}
}
page 46 "Sales Order Subform"
{
SourceTable = "Sales Line";
layout
{
area(content)
{
repeater(Control1)
{
// Skipped
field("No."; "No.")
{
trigger OnAfterLookup(Selected: RecordRef)
var
Item: record Item;
begin
Selected.SetTable(Item);
Validate(Description, Item.Description);
end;
}
field(Description; Description)
{
trigger OnAfterLookup(Selected: RecordRef)
var
Item: record Item;
begin
Selected.SetTable(Item);
Validate("No.", Item."No.");
end;
}
// Skipped
}
}
}
}