Prevent Duplicate Entry
I have a STOCK table with standard fields like Stk_Code, Stk_Desc, etc. The STK_CODE is defined as unqiue with custom error message. The issue I am facing now is that if the user enter an existing stock code when he was adding a new stock, the system will prompt using the custom error message but it will continue to create that record when the user choose Yes to proceed and ignore the message.
How to ensure that no duplicate of stock code is created in this table.