42
I would like to use a variable in the TableRelation filter instead of 'INDUSTRY'.
This is the code:
I think I understand what you mean:
you want to use a global variable in the table relation filter.
but unfortunately this is not possible, according to the documentation:
TableRelation Property - Business Central | Microsoft Learn
as an alternative to the table relation you can set the OnLookup trigger like this:
Share
Report
All responses (
Answers (
field(50517; "Industry"; Code[20])
{
DataClassification = ToBeClassified;
Caption = 'Industry';
trigger OnLookup()
var
DimensionValue: Record "Dimension Value";
DimensionValuesPage: Page "Dimension Value List";
MyVariable: Code[20];
begin
MyVariable := 'INDUSTRY';
DimensionValue.SetRange("Dimension Code", MyVariable);
if DimensionValue.FindSet() then begin
DimensionValuesPage.LOOKUPMODE := true;
DimensionValuesPage.SetTableView(DimensionValue);
if DimensionValuesPage.RunModal() = ACTION::LookupOK then begin
DimensionValuesPage.GetRecord(DimensionValue);
"Industry" := DimensionValue.Code;
end;
end;
end;
}
Don't forget to help the community by Verifying the answer and Like it if your question has been answered. It will let others know that the topic has verified answer.
Thanks & Regards,
Gian
you can use the global variable in table relation you can use the table field as Mohana said,
TableRelation="Dimension Value".Code where("Dimension Code" = field(YourFiled));
regards
I dont think we can use variable there but you can use a field.
TableRelation = "Dimension Value".Code where("Dimension Code" = field("field name"));
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
232,011
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
