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
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.
Comments
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
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.