Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012

    Unanswered: Cannot add Records; Join Key of table not...

    I am extremely new to access so I would appreciate as much help as I can get. I have been tasked with creating a database that stores product information and archives changes in price and attributes. This is what I am stuck on currently... an error message when trying to input into a text box reads "Cannot add records; join key of table "tblSciQuest' not in Record Set."

    Thank you in advance and I really do appreciate the help!
    Attached Files Attached Files
    Last edited by turntabl1st; 07-17-12 at 14:32.

  2. #2
    Join Date
    Apr 2011
    Please can anybody help, I really would like to know what I am doing wrong. Thanks again.

  3. #3
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Without opening the file, the error message is saying that you have a relationship defined between the table that you're trying to update and another table in the database. The problem is that the field that controls the link hasn't been included in the form performing the update.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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