What is AutoSplitKey??
Sets whether a key is automatically created for a new record placed between the current record and the
previous record.
This means when you enter a record in between two records, Dynamics NAV will split the last field of the
primary key group and create a new value and assign to the newly created record.
As an example if the user want to enter records between line 10000 and 20000 then system will split the line
no (last primary key) as below.
10000 10625 11250 12500 15000 20000
This is mainly used in the line tables where combination (concatenate) of fields been used as primary keys.
Following are the main conditions must met to use the AutoSplitKey :
The current key must be the primary key.
The last field in the primary field must be an Integer Data Type, BigInteger Data Type, GUID Data Type,
or Decimal Data Type field.
Let's just check how to set it..
As an example let's get the "Sales Line" (37) table and see how the primary key is been set. To do that just
follow the steps according to the image below.
Primary key of the "Sales Line" table : "Document Type,Document No.,Line No.".
Last field of the primary key is set an integer and it fulfill the criteria required to use "AutoSplitKey"
function.
As the next step, open the properties of the page "Sales Invoice Subform" (47) using development
environment. In the properties, go to AutoSplitKey and check the set parameter of it. In the
"Sales Invoice Subform" it has been set to yes, which means key will get split automatically if the user will
try to enter a line in between a record.
How Many Lines Can be Added In Between Records?
Maximum no of lines you can add is 13.