Small and medium business | Business Central, N...

Can't lookup Dimension values base on dimension the select Dimension Code

(0) Share

Report

Posted on by Romryan

Hi all

Can't lookup Dimension values base on dimension the select Dimension Code. An error placing the breakpoint on "Dimension Value".Get("FNo."); below shows up.Below is my code.

Field(50013; "FNo."; Text[30])
{

Caption = 'Fund No';

//DataClassification = ToBeClassified;
//TableRelation = Fund."No.";
TableRelation ="Dimension Value".Code where ("Dimension Code"= filter('FUND'));

trigger OnValidate()

var
"Dimension Value": Record 349;

begin

"Dimension Value".Get("FNo.");
FundName := "Dimension Value".Name;
//"FNo.":="Dimension Value".Code;

end;

}

Kindly assist

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: Can't lookup Dimension values base on dimension the select Dimension Code

1) You can use OnLookup of the Editbox to enter the code to open the lookup form and select the value

2) You can use TableRelation property of the editbox to connect it to specific table (bat you cannot include filter based on some settings or another variable).

I recommend the first option...
Suggested answer

JAngle 89 on at

Like (0)

Report

RE: Can't lookup Dimension values base on dimension the select Dimension Code

So you want the name of the fund from the dimension value table? I would try changing FNo to a code[20] as .get likes to have matching field types and primary key values only. I expect the primary key of the dimension value table is more than what you have. The alternative would be to use .setrange instead, so you don’t have to comply with the primary key of the table.
Suggested answer

Andy Sather on at

Like (0)

Report

RE: Can't lookup Dimension values base on dimension the select Dimension Code

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.