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

aquinco · 2016-08-09

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 · 2016-08-11

Like Kishorm Said Follow this easy Steps From this Link

RockWithNAV · 2016-08-09

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

Kishorm · 2016-08-10

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 · 2016-08-11

Like Kishorm Said Follow this easy Steps From this Link

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

Best Answer

Answers

Categories