wat is auto split keys
southindian
Member Posts: 247
can any one explain me in detail what is auto split keys,its other features and why it is incremented by 10,000????
0
Comments
-
Sets whether a key is automatically created for a new record placed between the current record and the previous record.
Applies To
Forms
Pages
Property Value
Yes if the key is automatically created for the new record; otherwise, No. The default value is No.
Remarks
To set this property to a value of Yes, the following conditions must be met:
The current key must be the primary key.
The last field in the primary field must be an Integer Data Type, BigInteger Data Type, GUID Data Type, or Decimal Data Type field.
http://mibuso.com/forum/viewtopic.php?f=23&t=17182&hilit=10000
http://mibuso.com/forum/viewtopic.php?f=23&t=34013&hilit=100000 -
Autosplitkeys is a form property that automatically generates key values for primary keys that end with an integer type field. An example is on the sales order subform. This form is linked to the header table by the document type and document number, and the autosplitkey generates the line number automatically. The reason why they selected the number 10000 is because that way you can insert lines between two existing lines. So if you have line 10000 and line 20000, the autosplitkey will automatically generate line number 15000 when you insert a line between those lines.0
-
ah yeah third... I thought there was a board property that warns you when others have replied when you post something.0
-
thanking you all for spending your valuable time in replying...... thank you once again 0 -
me, too...but it seems that it does not always appear...maybe if you have opened the page before the other user began to reply :-k ...anyway, back to my last day of work (leaving this evening 4 holidays :thumbsup: )DenSter wrote:ah yeah third... I thought there was a board property that warns you when others have replied when you post something.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 327 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

