I added a unique key to a free table. I expected it not to allow an insert if there was a duplicate key. That is not how it is working. Wanted a key that would not allow duplicates. Of course logically I will code it not to be any duplicated, but want a sure fire method so as there will not be any. What does does a unique key do and what else it there to use.

Brenda