Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    13

    Primary keys duplicates okay

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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/

  3. #3
    Join Date
    Dec 2003
    Posts
    13
    Originally posted by r937
    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

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •