Skip to main content

Notifications

Announcements

No record found.

Business Central forum

Dropdowns/ Lookup fields

Posted on by 249

In old C/AL development, key groups was solution to show drop downs. 

I already have below, and it's working. But i want my drop downs to have several fields. Currently on MonthCode is shown.

field(13; "Month Code"; Code[100])
{
TableRelation = "Months"."Month Code";
}
Categories:
  • Hang Profile Picture
    Hang 5 on at
    RE: Dropdowns/ Lookup fields

    Hi Nissay 

    Do you know how can i change the order of  fileds in the dropdown list

    Exam: 

  • dickson kimeu Profile Picture
    dickson kimeu 249 on at
    RE: Dropdowns/ Lookup fields

    It worked.

    Thank you.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dropdowns/ Lookup fields

    Well, to get the NEW button you should, on your table, use the LookupPageID property in which you specify a list page (which perhaps you should create) for your Months table. In this page you have to set the InsertAllowed property to TRUE (this property means that users can add records via that page ==> NEW).

    --

    Don't hesitate If you need more details or explanations.

    -------------

    Please verify my answer if you find my answer helpful. Doing so you'll show other community members that there was found a solution and you credit my help.

    -------------

    Best Regards,

  • dickson kimeu Profile Picture
    dickson kimeu 249 on at
    RE: Dropdowns/ Lookup fields

    Hello,

    It worked, but i can't see the NEW button to add values on the go for my drop downs

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dropdowns/ Lookup fields

    Hi Dickson,

    On your table, add a fieldgroup:

    fieldgroups
    {
    
       fieldgroup(DropDown;Field1, Field2);
    
    }
    
    

    And add fields you like as parameters to field group.

    you can check this link that gives more detailed instructions on how to use fieldgroups : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-field-groups

    --

    Don't hesitate If you need more details or explanations.

    -------------

    Please verify my answer if you find my answer helpful. Doing so you'll show other community members that there was found a solution and you credit my help.

    -------------

    Best Regards,

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Dropdowns/ Lookup fields

    In AL you have to do the same. Create a Field Groups on your table called DropDown and insert the fields you want in the dropdown page.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans