Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Unanswered: Unable to input duplicate data

    Hello,

    I have a table with 3 primary keys and indexes that are set to Yes (duplicates ok). I have other fields that the index is set to No. When I input my data in the fields that have no data and want then to have duplicates I get a message saying duplicates not allowed. Even when I change these fields to Yes (duplicates ok), I still get the message.

    What can I do to be able to input duplicates.
    Any help would be appreciated.
    Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You can't have three primary keys. Primary keys must be unique by definition.


    Read through here and let me know if you still have questions:

    Fundamentals of Relational Database Design -- r937.com
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jul 2009
    Posts
    3
    You are able to have more than 1 primary key.

    http://office.microsoft.com/en-us/ac...546931033.aspx

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    That's called a composite key. You can use multiple fields to form a SINGLE primary key.

    Is that what you're trying to do?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Jul 2009
    Posts
    3
    Yes that's what I currently have.

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Do you have an example of data you're entering that throws the error? Is the combination of keys involved unique?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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