Is it possible to change the field caption with the value of another table field.

(0) Share

Report

Posted on by Dyavari Sandeep Yadav

132

if it is possible to do then please help me to archive this. Here I tried by assigning the same field value. But I am unable to get the value of a field that is from another table.

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

tanya07 1,638 on at

Like (0)

Report

Hi,

Why would you want to change the field caption with the value of another table field?

Can you please elaborate more?

You can definitely assign the value of one field to another.

Thanks,

Tanya Kharbanda

Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has a verified answer.

Was this reply helpful? Yes No
Dyavari Sandeep Yadav 132 on at

Like (0)

Report

Thanks for the reply @tanya kharbanda. Here I am doing the task on dimensions. There I Have to display the related values based upon the caption.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi DyavariS ,

You please refer any matrix page in the system, for ex. Item by location, see the image below, please check this page in design mode, it will help you to understand how to change field caption dynamicaly.

Thanks.

Was this reply helpful? Yes No
Verified answer

Techworld 106 on at

Like (0)

Report

Hi,

If you mean that you have another dimension which you are using in Business Central apart from Global Dimension 1 and 2 and you want to display the name Caption Dimension Code of dimension selected on Customer Card then you can use Caption Class by changing Last Value in Caption class 1,2,3 or 1,2,4 it will appear for the Dimension selected on General Ledger Setup.

and adding two fields in Table Extension

field(90000; "SD 3 Code"; Code[20])

{

Caption = 'SD 3 Code';

CaptionClass = '1,2,3';

TableRelation = "Dimension Value".Code WHERE("Global Dimension No." = CONST(3),

Blocked = CONST(false));

trigger OnValidate()

begin

ValidateShortcutDimCode(3, "SD 3 Code");

end;

}

field(90001; "SD 4 Code"; Code[20])

{

Caption = 'SD 4 Code';

CaptionClass = '1,2,4';

TableRelation = "Dimension Value".Code WHERE("Global Dimension No." = CONST(4),

Blocked = CONST(false));

trigger OnValidate()

begin

ValidateShortcutDimCode(4, "SD 4 Code");

end;

}

Is your organization anyhow is using more than 8 Dimension and you want to reflect 9th Dimension value is it the Case,?

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Hi, hope the following will help.

https://yzhums.com/13188/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Umang Srivastava 100 on at

Like (1)

Report

you can check the below code in page sales order subform where shortcut dimensions are shown on the basis of different dimensions values selected in GL setup.

field(ShortcutDimCode3; ShortcutDimCode[3])

{

ApplicationArea = Dimensions;

CaptionClass = '1,2,3';

TableRelation = "Dimension Value".Code WHERE("Global Dimension No." = CONST(3),

"Dimension Value Type" = CONST(Standard),

Blocked = CONST(false));

Visible = DimVisible3;

trigger OnValidate()

begin

ValidateShortcutDimension(3);

end;

}

to setup like the above one now you need to define the caption likewise in codeunit 343 "Dimension CaptionClass Mgmt" you can have a look on this codeunit it will give you better idea to achive custom caption.

Was this reply helpful? Yes No