>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
Unique keys really don't have much to do with unique records. They really mean that only one key will be stored in the index, but multiple records may have the same key. What you want is a candidate index.
Whoops, candidate indexes are not available for free tables, only tables in a DBC.