Primary Key - Duplicate OK ?

M

Matthew

hello again,

is there way to set the Primary Key to Duplicate OK ? Ex. I could have an
account name "Matthew" & it could repeat multiples time in the same table. Is
there a way around this ? any help would be appreciated.
thanks
matthew
 
D

Douglas J Steele

By definition, Primary Keys cannot contain duplicates. They're not Primary
Keys if they contain duplicates!

Sounds as though what you've picked as a Primary Key isn't adequate. If you
can't find a combination of fields that's sufficient to be unique, you may
have to use an Autonumber field instead.
 
Top