Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    182

    Unanswered: Update statement conflicted with TABLE REFERENCE constraint FK

    I am getting the above error when I close my application after adding a new record. The reocrds are being added to the correct tables but this error keeps coming up "Update statement conflicted with TABLE REFERENCE constraint FK" how can I get rid of it.

  2. #2
    Join Date
    May 2004
    Posts
    19
    check your relationships and your indexes

  3. #3
    Join Date
    Apr 2004
    Posts
    182
    I am adding to the PK table using a data entry form then I am using addnew to update the FK table. The data is being added. I have a one to one relationship. What do I need to check in the indexes.
    Thanks

  4. #4
    Join Date
    May 2004
    Posts
    19
    I do not know your exact problem. You could remove your FK's and test your update again. Then you'll see if you are still getting an error message.

Posting Permissions

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