Blank record insert in table

vijay_g
Member Posts: 884
hi,
i have made a form(Tabular) based on purchase header, while putting only posting date in form record has inserted in table with blank primary key value.
what's happening....
i have made a form(Tabular) based on purchase header, while putting only posting date in form record has inserted in table with blank primary key value.
what's happening....
0
Comments
-
You can go to desing mode of table and change value of "NotBlank" Property to "Yes" for your primery key field, then it will not insert record with blank primery key value.Rakesh Patel
Navision Developer0 -
That's the normal way if you don't enter a value to the primary key or predefine some values by properties or by code. Just go to the last record in your form and go forwards to a new record. I would guess to set the property InsertAllowed to No."Money is likewise the greatest chance and the greatest scourge of mankind."0
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
- 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
- 320 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