Results 1 to 2 of 2
  1. #1
    Shabana123 is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2012

    How to create two primary keys

    Dear Experts,

    I have one query which is already stored. Now I need to add one more query and update the same. I need to refer the primary key which is there in the first query and continue doing the operation. Please suggest what is the best method to go about it.

    Thanks in advance

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    You are going to have to describe your situation more clearly. Please tell us in plain English WHAT you are trying to accomplish. Post the SQL for your query (ies). Perhaps you could give us some sample data to show the issue?

    The title of your post is very misleading. One table --> one primary key. But you can have a compound primary key...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  2. Query returns Primary Keys
    By funkygoorilla in forum Queries
    Replies: 4
    Last Post: 10-28-2011, 01:11 PM
  3. Query using the same primary keys.
    By Franuzz in forum Queries
    Replies: 1
    Last Post: 04-11-2011, 11:27 AM
  4. Multiple primary keys
    By elektrisk in forum Access
    Replies: 5
    Last Post: 02-11-2010, 04:39 PM
  5. Primary and Secondary Keys...
    By LittleOleMeDesigns in forum Database Design
    Replies: 5
    Last Post: 07-24-2009, 11:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums