Skip to main content

Hello

 

I have below Supplier  data model

 

How can i prevent entering a duplicate value?

In the portal, it is designed to add, edit delete but it allows to enter duplicate data

 

I'm not sure how unique constraint works here but  I added an Indexes unique constraint but it doesn't work. Please advice

 

Below is the values on index column, unique is also ticked

Thanks in advance

I just so happen to be doing something similar today, and for me it is working as intended.

The only thing I can think of is that maybe you forgot to update your database (Creation > Generate definition > Generate source code > Execute source code)?


Hi Jkruter,

 

Thank you! yes for some reason after i repeat the deployment procedure and it works