It is possible to use a variable in the TableRelation filter inside a field?

(1) Share

Report

Posted on by Roberto Suarez Alemany

I would like to use a variable in the TableRelation filter instead of 'INDUSTRY'.

This is the code:

field(50517; "Industry"; Code[20])

{

DataClassification = ToBeClassified;

Caption = 'Industry';

TableRelation = "Dimension Value".Code where("Dimension Code" = filter(= 'INDUSTRY'));

Thanks in advance,

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (1)

Report

I dont think we can use variable there but you can use a field.

TableRelation = "Dimension Value".Code where("Dimension Code" = field("field name"));

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Gianfranco C. 370 on at

Like (1)

Report
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:

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I think you can refer to the practice in the standard Sales Line.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No