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.
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.