Options

Change Default Filter Column

matttraxmatttrax Member Posts: 2,309
On the item card, entering a new record. Doing a find as you type on Product Group. Unfortunately the default filter column is the item category, rendering this basically useless. How do you change this?

Answers

  • Options
    TroelshTroelsh Member, Microsoft Employee Posts: 79
    When doing FAYT we show the columns that are defined as keys on the related table - in this case table 5723. Unless a Field Group named "DropDown" is defined - then we use that for FAYT.

    In this case you can add Code as key and create a Fieldgroup "DropDown" and select Code, Description

    - this will be a global change that will impact all scenarios where you want to lookup in that specific table. So it may impact other scenarios where you actually want something else for dropdwon columns.

    Troels Bent Hansen
    Senior Program Manager
    Microsoft Dynamics NAV


    ****** This posting is provided "AS IS" with no warranties, and confers no rights ******
  • Options
    matttraxmatttrax Member Posts: 2,309
    Works great. Thank you very much.

    On a similar note, what other options are available besides DropDown?
  • Options
    krikikriki Member, Moderator Posts: 9,090
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    mihail_kolevmihail_kolev Member Posts: 379
    Is it possible to set the default key of sorting of the dropdown... for ex. Employee's last name, not the PK No. ??? :-k
    -Mihail- [MCTS]
  • Options
    bennie_de_beerbennie_de_beer Member Posts: 43
    Yes. Thanks it solved the problem.
Sign In or Register to comment.