All about Microsoft Dynamics NAV and Business Central
How to Create Unique Keys in AL Development/Business Central
Spring Release 2019 of business central comes up with new features for creating unique keys
Today we will see how to create unique keys in table
While creating second keys you can add an additional parameters said ‘Unique’. This will not allow duplicate values in the field where unique parameter is mentioned.
Now we will see this validation works on business central. Here we are trying put same description which is throwing error because of unique key.
You can define multiple unique keys in one table.
Points to Remember
Field can have empty value that means empty value is also value.
I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development.
Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin
Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs.
Certifications:-
Microsoft Certified Technology Specialist -Dynamics
Microsoft Sure Step Certified Professional
Moderator at DUG Forum
Specialties: • ERP Implementation
• Client/Server Programming
• Coding, Testing, troubleshooting and documentation.
• Database Tuning and SQL
• Database Performance
• Debugging large programs
• Project Management and Resource Management.
View all posts by Ammolh Saallvi
One thought on “How to Create Unique Keys in AL Development/Business Central”
One thought on “How to Create Unique Keys in AL Development/Business Central”