How to make my table autofill field with next number in line?

aquinco

Hi everyone. I want to make my table field "No." to do the same as the same field in the table 36 "Sales Header". To fill with the next available value. For example, last valuein table was 1001, and when I go to new line, it fills automatically with 1002
I know that everything is in the code of that table but I just got really lost in the forest of lines of code and variables.
Thanks

rajavenkat74@gmail.com

Like Kishorm Said Follow this easy Steps From this Link

RockWithNAV

That Field must be a part of Primary Key. Make Autosplitkey Property YES of that Page.

Kishorm

Autosplitkey is used on sub forms or worksheets when adding new lines so this is not what you need. Have a look at this article which describes what you need to do instead...

https://blogs.msdn.microsoft.com/nav/2013/08/05/nav-patterns-of-the-week-no-series/

Regards
Kishor

rajavenkat74@gmail.com

Like Kishorm Said Follow this easy Steps From this Link