Dynamics NAV AUTOSPLITKEY (Automatically inserting a primary key value each time a new record is created)

Hello there. You could be new to CSIDE Dynamics NAV Development & in need of a way to automatically generate primary key value each time a new record is inserted in the table.
Such a method has been used in areas like Sales Lines, Gen. Journal Line TABLES and others.
Considering the Sales Lines Example, the line No. is automatically inserted each time a new record is created.
Here is how to do it.

• Create a table and make sure the field whose values are to be automatically inserted is of type INTEGER and part of the primary key.
• Create a page where users enter the records. Set the AUTOSPLITKEY property of that page to yes
• Try running the page
• Insert some values

In my example;

I created a STUDENT table where STUDENT ID is automatically created each time a user creates a new student.

I also created a STUDENT page and set the AUTOSPLITKEY property of the page to yes

That was all i had to do.

Notice how that field is populated each time a new record is inserted.
click here for more information

Was this blog helpful ?
Please leave a comment