Feature Request - Duplicate Prevention

User 596f3ef229

19-03-2009 23:50:46

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?

User 596f3ef229

20-03-2009 01:34:16

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

ChemAxon fa971619eb

20-03-2009 07:26:07

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