Autonumber

Business Central/NAV Developers Forum
1

Hello, is it possible to create an autonumber field in a table in Navision 4.0x without code? I am running SQL Server 2005 as my database.

2

Hi John,

Can you give a more detailed description of what yoiu what to acheive. On the face of it using the AutoIncrement on an integer field would do for you.

Happy St. Patrick’s Day [<:o)]

3

Create a field of the field type Integer and set the “AutoIncrement” property of this field to Yes.

This will create the autonumber functionality on this field.

4

Thanks. Do I do this in SQL Server? If so, where? I am running SQL Server 2005 through MS SQL Server Management Studio and I don’t see that Property.

5

Nope, you do this directly in the Navision table designer.