New Drop Down window in Microsoft NAV 2009 using Fields Groups

New Drop Down window in Microsoft NAV 2009 using Fields Groups

  • Comments 4

I have now been asked many times how the new Drop Down window in Microsoft NAV 2009 is defined, so let me give you an example on how this works.

In this screen dump, I have just clicked the Drop Down arrow on the field ”Bill-to Customer No”, on the Customer Card, and our new Drop Down window appears displaying the columns No., Name, City, Post Code, Phone No. and Contact.

image

So how do I define that when I click “Bill-to Customer No.” it displays a Drop Down? And how are the columns defined which are displayed in the Drop Down?

Let us look at a field which actually shows a List page and change this field to show a Drop Down. This could be ex. “Post Code” also found on the Customer Card.

Let us see what happens when I click “Post Code”:

image

So in standard NAV 2009 we show a List page where the use can select from the available Code and Cities found in the demo database. I would like to change this into a Drop Down so let us go into the Object Designer and explorer why I shown a List page when clicking the Post Code field.

My first thought is to look at Page 21 in the Page Designer and look at the properties for “Post Code”:

image

But since nothing is specified on the “Lookup” property this must be on table level. In table 18 you find the following code  “PostCode.LookUpPostCode(City,"Post Code",TRUE);

image

With this on the OnLookup trigger we will show a List page and not a Drop Down, so let us delete what is on the OnLokup trigger and see how the “Post Code” fields now behaves in the RoleTailered client:

image

So now I got my Drop Down on “Post Code” but I actually want to sort the columns different and add other columns to the Drop Down. To do this I used a new thing we call “Fields Groups”.

Since when I look at the “Post Code” on the customer card we actually lookup in Post Code table 225, so to change the columns displayed we need to look at this table, so back to Object Designer and design table 225.

In design mode click “View” and notice a new field called “Field Groups”. Notice that this is blank, so the “Code” and “City”  which are displayed in Drop Down above are shown because these fields are Primary Keys specified on the Table.

image

Now let us define the columns shown in the Drop Down window of “Post Code”.

In the Name type “DropDown” and in group select the assist button and select City, Code and City Search:

image

Your Field Group should now look like this:

image 

 

 

 

 

 

 

Now compile table 225 and go back to your Customer Card. If you had one open already you will need to reopen since we have changed the underlying data.

Your Drop Down now displays like this:

image 

We have now completed created our new Drop Down window, but before I end this blog I would to like show you a bit more what you can do with this Drop Down.

I have been been in the NAV group for almost 10 years now so I’m a keyboard shortcut addict so let me show a small tip.

While standing on the “Post Code” field press “ALT+ARROW DOWN”, Drop Down will show up.

Now type “New”. The Drop Down will now be sorted on all cities starting with “New”:

image

You might have noticed that “City” is bold in the Drop Down. This signals that the Drop Down will be searched based on upon the field “City”. So in this case when we type “New” we will see the Cities which start with “New”

Now let us make “Code” the default.

Press “ARROWDOWN” to get down into to Drop Down.

Press “ARROWRIGHT” to get to the “Code” column. Notice that “Code” now becomes bold, and if you are still searching on “New” the list will become blank:

image

 

Now type “US“ and your Drop Down window will now be sorted on all codes which is starting with “US“:

image

Also notice that “Code” going forward will be column to sort on as this information is stored in the Personalization store.

So here you have it, my first blog ever.

Thanks,

Claus Lundstrøm, Program Manager, Microsoft Dynamics NAV

Leave a Comment
  • Please add 7 and 2 and type the answer here:
  • Post
  • Hi,

    sounds good. Is there way to disable those New and Advanced links ?

    Thanks.

  • I am also interested in disabling the Drop Down in Sales Order, Field Item No., is there any posibility?

    Greetings

  • Hi, Ike,

    You can disable the New link by setting the InsertAllowed property on the page to No.

    You cannot disable the Advanced link.

  • Hi! Is there any way to apply conditions to 'New' link? so that under some conditions different pages (e.g. Vendor Cards)are opened.

    As an example: in RU localisation there are 4 Vendor Types (Vendor,Resp. Employee,Tax Authority,Person) which are stored in same 23 table 'Vendor'. There are 4 different Pages - Vendor Cards, one for each type, but in dropdown list when you click 'New' same Page is opened for any Vendor Type to create new record which confuses users.

Page 1 of 1 (4 items)