Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2010
    Posts
    7

    Unanswered: Two Primary Keys in a weak entity

    Hey

    I'm trying to craete a table where two attributes make the PK, but access only allows me to have one PK.

    Is identifying the composite PKfor design purposes only or is there a way around this on Access?

    Thanks

    Whitebear

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You only have one PK, but it is a composite of two columns. To do this in the GUI, highlight both columns (you can use CTRL IIRC) and then click Primary Key.

  3. #3
    Join Date
    Mar 2010
    Posts
    7
    Thanks, thats sorted it

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by pootle flump View Post
    you can use CTRL IIRC
    where's the IIRC key? is that on one o' them nancy british keyboards?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I'm not sure - I only have access to a Fine Upstanding Lovingly Engineered Stiff Upper Lipped British Keyboard.

Posting Permissions

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