Field Validation
vikas
Member Posts: 46
Hi,
I have created a field called "Test" in customer table which is also displayed on the customer card.
Whenever an user accesses the customer card & creates a new record he should mandatorily enter the value in the "Test" field.
To do this i have enabled the "Not Blank" of this field, but it did'nt work.
Please help me in this regard
Thanks & Regards,
Vikas
I have created a field called "Test" in customer table which is also displayed on the customer card.
Whenever an user accesses the customer card & creates a new record he should mandatorily enter the value in the "Test" field.
To do this i have enabled the "Not Blank" of this field, but it did'nt work.
Please help me in this regard
Thanks & Regards,
Vikas
0
Comments
-
It will not work this way.
You can check if the field is empty on the table triggers like the OnModify.
But the best way to do this might be on the Form in the OnNextRecord trigger with code like:
If Test = '' THEN
MESSAGE(Text50000);
EXIT(Steps);
END;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
- 333 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