Options

Disable Standard Nav Sorting

parambparamb Member Posts: 85
edited 2014-02-24 in NAV Three Tier
Hi All,

I would like to know if we can disable Standard Nav Sorting in sub Pages like Sales Order Line or Purchase Order Line.

Thanks in advance.

Comments

  • Options
    ReinhardReinhard Member Posts: 249
    edited 2014-02-21
    Ultimately, the records must be sorted in some way.
    In the source table view or sub form view property you can specify a key to use. It can be any key defined on the table.
    As you're probably aware, any key is automatically appended with the PK.
    Let me know if that helps, or maybe let me know more specifically the problem you're having and why the sorting should be changed.

    *Edit*
    Also note that in the SO and PO subforms, they have "Auto-Split Key" property enabled. So in that instance you might have to keep the Primary Key if users will want to insert any records...
    - Reinhard
  • Options
    parambparamb Member Posts: 85
    Thanks for your help.

    What I am looking for is to disable the option for the end user to change the sorting.
  • Options
    geordiegeordie Member Posts: 655
    paramb wrote:
    Thanks for your help.

    What I am looking for is to disable the option for the end user to change the sorting.

    Which version are you running? There's for sure a more clever option, but in NAV 2013 specifying in source table view property of the page a key not existing in the table makes disappear for users the option to change sorting.
  • Options
    parambparamb Member Posts: 85
    2009 R2
Sign In or Register to comment.