Table Relation Columns

(1) Share

Report

Posted on by LM-26090852-0

145

Good day,

I have this field below with table relation to Dimension 4.

I would like to modify the selection behavior in the "Proyecto" field on my page. Specifically, when a user selects a dimension value, I want the field name to be displayed instead of field code(PK).

I understand that this may seem as simple as changing the value of code for same letters i have on field name, but I need that field code remains numeric. This is necessary for indexing the dimension values as letters are not acceped.

Is there any way to achieve this?

Thank you for your assistance.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (1)

LM-26090852-0 145 on at

Like (1)

Report

Table Relation Columns

Thank you so much for your answers!! It works!

PS: Yun Zhu, thanks for always make everything easier. If you had a course, I will step forward without hesitating.
Verified answer

YUN ZHU 84,728 Super User 2025 Season 1 on at

Like (1)

Report

Table Relation Columns

This is very simple, just add the following property.

More details: https://yzhums.com/22220/

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 17,404 Super User 2025 Season 1 on at

Like (3)

Report

Table Relation Columns

Yes, Its possible and verry simple.

add code in the onvalidate trigger of the field as below.

field(50000; "Payment Process Profile Code"; Code[50])

{

DataClassification = ToBeClassified;

TableRelation = "Payment Process Profile";

Caption = 'Payment Process Profile';

Trigger OnValidate()

var

PPP: Record "Payment Process Profile";

begin

if PPP.Get(Rec."Payment Process Profile Code") then begin

Rec."Payment Process Profile Code" := PPP.Name;

end;

end;

}

Final op.