hello

how can i have a primary key that can have duplicates as the data in my database requires this for some of its tables..... or is this not possible in access?

bfn

Bekka

it is not possible at all in any database that understands primary key

primary keys, by definition, are unique and not null

however, you could have a composite primary key, of which one of the columns will have duplicate values

what are you trying to do? what are your columns values?


rudy
http://r937.com/

the values are all numbers that i am entering.
if the table has a composite key one of them can have duplicate keys but how can i tell it to allow it to? this is access

you can tell access to allow a composite primary key by highlighting more than one row in table design view and then clicking the primary key icon

you may have to un-primary the single column first


rudy