[AccessD] Unique index... NOT!!!

I suspect that either Mname or Suffix in one record holds a null value while
in the other records it is an empty string "", which is not the same thing
as Null. It could also be that one record has the first name as "Jay" and
the other has "Jay ". The space on the end being the tiebreaker.

However, why are you imposing this unique index anyway? Where does it say
that two people cannot have the same name?

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart
Sent: Thursday, March 22, 2007 2:09 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Unique index... NOT!!!


     Access 2003
     tblName
     NameID FName MName LName   Suffix
     1      Jay    Ray  Johnson   Jr
     2      Jay         Johnson
     5      Jay         Johnson
     Name ID is the primary key.
     There is a unique index on FName, MName, LName, and Suffix.
     Why is it allowing the entry of Name ID # 5?
     It is not enforcing the unique index. 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com