How can I check for duplicate field values?

Classic Servoy
1

I can’t seem to find this… How can I find out whether the value entered in a field is unique to that table?

I can think of some rather long ways, but I’m sure there must be a simple method I’m just not seeing.

2

I would use a sql statement to check if there is already a record with the same value or do a find.