Table Relation Columns

(1) Share

Report

Posted on by LM-26090852-0

175

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

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (3)

Report

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.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

This is very simple, just add the following property.

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

Thanks.

ZHU

Was this reply helpful? Yes No
LM-26090852-0 175 on at

Like (1)

Report

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.

Was this reply helpful? Yes No