Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    6

    Unanswered: Junction table does not take duplicates

    Hy...I have database with multiple tables in which tbOrder and tbItem are in many-to-many relationship. So why cant i input data into junction table as:

    orderID itemID
    2 2
    2 2

    Indexes on off or Allow duplicates. But i'm still getting duplicate error.

    I'm attaching my database file if someone could help me with this issue. Thank you.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2006
    Posts
    6
    There was my fault becouse I've set orderID itemID as primary keys and therefore this obviously can't go through. I've added unique key in my table orderItem and remove primary keys from orderID itemID and now all is working as supposed to.

Posting Permissions

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