Add Dropdown to New field

(1) Share

Report

Posted on by DS-15051354-0

154

I have a question. I just created a new field (added to journal line and G/ L tables) and I wanted to add dropdown values to this field. What s the best way to do this.

Thanks for your help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can add your field to the dropdown fieldgroup.

tableextension 50000 "Item_TNG" extends Item
{
fields
{
field(50000; MyField_TNG; Code[20])
{
}
}

fieldgroups
{
addlast(DropDown; MyField_TNG) {}
}

}

Was this reply helpful? Yes No
Verified answer

VK_Karangiya_MCP 51 on at

Like (1)

Report
Copy link

Link copied!

Hello DS-15051354-0 ,

You can create a new enum object, add your required values to it, and then assign this enum object to your new field.

Was this reply helpful? Yes No
Suggested answer

KP - Solution Archi... 658 on at

Like (1)

Report
Copy link

Link copied!

Hi

Depending on your requirement if you want dynamics values in your dropdown you can add a table relation to its master table

If you have static values you can create an enum and assign the enum to the new field,

Hope this helps.

Thanks,

KP

Was this reply helpful? Yes No
Suggested answer

One And Only Naveen 460 on at

Like (1)

Report
Copy link

Link copied!

You can try something like below on table -

field(4; "Quarter"; Option) { DataClassification = ToBeClassified; OptionMembers = "","Q1","Q2","Q3","Q4"; }

or

Something like this on page for connected data from other table-

field("Dimension"; Rec.Dimension)

{

ApplicationArea = All;

ToolTip = 'The dimension to be used in the trial.';

trigger OnLookup(var Text: Text): Boolean

var

LookupPage: page "Dimension List";

LookupRecord: Record Dimension;

begin

LookupPage.LookupMode := true;

LookupRecord.SetRange(Blocked, false);

if LookupRecord.FindSet() then begin

LookupPage.SetTableView(LookupRecord);

if LookupPage.RunModal() = Action::LookupOK then begin

LookupPage.SetSelectionFilter(LookupRecord);

LookupRecord.FindSet();

Rec."Dimension" := LookupRecord.Code;

end;

end;

end;

}

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-field-groups

https://yzhums.com/5774/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, just add some info: Please note that sometimes you may encounter the following problem.

Dynamics 365 Business Central: Why are the newly added fields in drop-down not displayed? (e.g., adding item Search Description to DropDown fieldgroup)

https://yzhums.com/57334/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Maybe this will help you proceed quickly.

To add a dropdown to your new field in Business Central, you have two standard options:

✅ Option 1: Use an Enum (Recommended for fixed values)

Create a new enum object with the dropdown values.

Assign the enum to your field in the table.

enum 50100 "My Dropdown Options" { Extensible = true; value(0; "Option A") { } value(1; "Option B") { } value(2; "Option C") { } }

Then in your table:

field(50100; "My Field"; Enum "My Dropdown Options") { Caption = 'My Dropdown'; }

✅ Option 2: Use a Lookup Table (if values change over time)

Create a table with the values.

Then in your main table field, set a TableRelation to the new table.

field(50101; "My Field"; Code[20]) { TableRelation = "My Value Table".Code; Caption = 'My Dropdown'; }

Choose based on whether your values are fixed (enum) or dynamic (table).

Mark below checkbox to make this answer Verified if it helps you. Let me know if you need help creating the enum or table.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,941 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You need to extend the enum to get in your new custom field and then fieldgroupsis the key, exactly the same way we use to achieve in NAV versions wayback.

fieldgroups
{
addlast(DropDown; "Custom Column") { }
}

Was this reply helpful? Yes No