Table accepting duplicate entries in primary key field

[elviajero]

I have a table set up with a text field as my primary key. It is an Access front with a SQL back.

My impression was that my user would get an error message if they tried to enter a duplicate entry in a primary key field. I have looked closely at the entry to see if there might be a space, a different case character, or something to make the entries different. There is not. I'm stumped.

 

[PamelaG]

Hi Elviajero!

To prevent duplicates in a field, set the indexed property (bottom of the design screen) to No duplicates.

Pamela

http://www.accessinsight.com

 

[Guest_imported]

Thanks, Pamela.