Robert L. Stewart
rl_stewart at highstream.net
Thu Mar 22 13:08:30 CDT 2007
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.