Table Relation Columns

(1) Share

Report

Posted on by LM-26090852-0

201

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)

Sort by

Suggested answer

Khushbu Rajvi. 22,206 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

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 99,322 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 201 on at

Like (1)

Report
Copy link

Link copied!

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