Ensure Unique (select from Right-click Menu of Database Table).
Ensure unique field values.
This is a tick box (located on this right-click menu item) that can be ticked to ensures that the currently selected field will always have unique values.
This option is useful for building key fields to join tables. If you attempt to assign a duplicate value to the field a warning message will appear.
Note, right-click access to this function is only available when right-clicking on a column header in the database table.
See Also