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.
- Not supported in table extensions.
Hope this will help you ..