Marko Saric

                Back in the days it was so easy, right? Design a table, add any field as a secondary key, and use it as you like to sort the data and do any calculation you like. Nowadays you have no access to base tables therefore the only option is to make extension of table definition. I won’t speak much about this since it is very nicely described in Microsoft documentation: Table Keys - Business Central | Microsoft Learn                 What I want is to review are a few possibilities of data sorting you can use in Business Central and, here is the nice part, regardless of are the fields part of the keys or not! Let’s start by creating a simple table for this purpose: And also, the page: Publish and enter some data for example like this: Notice that data is always sorted by primary key by default. So, let’s play. I will use actions to sort the data differently, so let’s add some actions to sort the date using the SetCurrentKey function: SetCurrentKey Function (Record) - Dy