Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
Navision Financials
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
310
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Auto numbers
anolis
Member
Posts:
16
2000-11-03
edited 2000-11-04
in
Navision Financials
Hello!
I just can't figure it out.
When I create a new table, I want the Primary key to be a number.
I want this number to be automatically generated, using the custom configuration settings of Navision.
How do I do that?????????
0
Comments
Luc_VanDyck
Member, Moderator, Administrator
Posts:
3,633
2000-11-03
You have to create a form for that, and set the AutoSplitKey-property of that form to 'YES'.
No support using PM or e-mail - Please use this forum.
BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
0
anolis
Member
Posts:
16
2000-11-04
Thank you very much!
When I do this, the primary key must be an integer or decimal.
Is it possible to use a CODE ot TEXT?
0
Luc_VanDyck
Member, Moderator, Administrator
Posts:
3,633
2000-11-04
Not with AutoSplitKey, it's only numeric.
If you want to work with No. Series, than have a look at Table 27 Item (Insert trigger) and Codeunit 396 NoSeriesManagement.
No support using PM or e-mail - Please use this forum.
BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
0
Sign In
or
Register
to comment.
Comments
When I do this, the primary key must be an integer or decimal.
Is it possible to use a CODE ot TEXT?
If you want to work with No. Series, than have a look at Table 27 Item (Insert trigger) and Codeunit 396 NoSeriesManagement.