Feature Request - Duplicate Prevention

Would it be possible to add a feature to the schema editor where you can assign a field as unique to prevent duplicate values of that particular field?





For example, to prevent a user from entering a new row with a compound ID or batch ID that has already been entered before. This would be quite useful when combined with the "required" setting.





Would I acheive the same result by adding a new index for the required column specifying "unique keys" as shown in the dialog below?

never mind. i added a unique key index using the dialog shown above and it does indeed prevent duplicate rows.

Yes, adding an index with a unique constraint is the best way to acheive this.





Tim