How to create line No ?

Sai_123

Hey ! Actually I'm new learner in dynamic nav Actually i created two tables and in Pages One cardpage and Listpage, And My Line Number Auto increment Is working in table when i Run, But Not working In CardPage When i do Run. So kindly help me up Guys.!

Sai_123

If anyone Knows Kindly let me know!It would be Helpful

navuser1

Use Autosplitkey propertities in Page level

Sai_123

Didn't work ! i used that properties..!

aceX

In NAV, you can use Autosplitkey property for this purpose. But when you use that property the values are incremented for 1. This is practice mostly for ledger tables where Entry No. is the key. In your case if this is the Line table where Line No is one of the keys, you should use function or insert the code OnInsert trigger on your table:

global var Record YourTable
global var Integer LineNo


function GetLineNo
-return value Integer

OnInsert
GetLineNo(Rec);


LOCAL GetLineNo:Return Integer
IF YourTable.FINDLAST THEN
LineNo := YourTable."Line No." + 10000
ELSE
LineNo := 10000;

EXIT("Line No.");


I hope this can help you. But before continue to develop in NAV, please read some books. Here it is one example:
http://www.mergetool.com/Data/MGT/CalProgGuide.pdf

Slawek_Guzek

@acex I think you've mistaken AutoIncrement with AutoSplitKey

@sai_123 AutoSplitKey is the property to be used, but it only works when the integer field you want to be auto-numbered is a part of a primary key on a table, and only when the integer field is the last one in the PK definition. If this is not the case you need to add some code to handle this.

kriki

[Topic moved from 'Navision DOS' forum to 'NAV Three Tier' forum]