web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Dropdowns/ Lookup fields
Business Central forum

Dropdowns/ Lookup fields

(0) ShareShare
ReportReport
Posted on by dickson kimeu 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:
Other
I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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,
    
                      
    
                    
    
                        
                        
    
                            




 





 






 





 


    
                        
    
                         
                      
                          
                       
                        
                            
                            
     
                              
                            
    
                            
                            
                            
                                
                            
                        
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
            
            
        
         
        
            
        
  • 
          
    
            
    
              
    
                
    
                  
    

                    
    
                    
                    
    
                        
                         
                         
                        
                    
    
                    
                      
    
                     
    
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            dickson kimeu Profile Picture
        

    

  
                        
    
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                dickson kimeu
                249 
                
        
                
                
             
         

            
                
                        
                 
            

    


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


 on  at 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
    
                        
    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 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
    
                        
    It worked.
    

    Thank you.
    

                      
    
                    
    
                        
                        
    
                            




 





 






 





 


    
                        
    
                         
                      
                          
                       
                        
                            
                            
     
                              
                            
    
                            
                            
                            
                                
                            
                        
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
            
            
        
         
        
            
        
  • 
          
    
            
    
              
    
                
    
                  
    

                    
    
                    
                    
    
                        
                         
                         
                        
                    
    
                    
                      
    
                     
    
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            Hang Profile Picture
        

    

  
                        
    
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                Hang
                5 
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
    
                    
    
                        
    
                        
    
                        
                          
                        
                      
    
                    
    
                  
    
                
    
              
    
              
    
                
    
                  
    
                    
    
                      
    
                        
    Hi Nissay 
    

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

    Exam: 
    
                      
    
                    
    
                        
                        
    
                            




 





 






 





 


    
                        
    
                         
                      
                          
                       
                        
                            
                            
     
                              
                            
    
                            
                            
                            
                                
                            
                        
                        
                  
    
                
    
              
    
            
    
          
    
        
    • 
        
        








 
                              
                            

                                

                                    

                                        
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

        

        
        





 





 








    
    

 
















    
    
    

    
        
        

            
            
News and Announcements

            

            
            
            Check out the Community Spotlight Video Series
            

            
            
        
 
    



        
            
            

                
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 > Business Central 
 
                        
 
                         









 





 










 





 






 
























 





 











  
                         

                            Last 30 days
                            Overall leaderboard 
                        

              

               
            
        

        

    






    
    

        
Featured topics

    

    

  

        
        




 





 


        

        
            

                
Product updates
 
                

                Dynamics 365 release plans