Hi experts, when I try to delete from tblCSCBookingDocument, I get this error: The DELETE statement conflicted with the REFERENCE constraint "FK_tblCSCBookingDocumentSelections_tblCSCBookingDocument". The conflict occurred in table "dbo.tblCSCBookingDocumentSelections", column 'CSCBookingDocumentID…

Did you try any solutions from here? [image] Foreign Key Issue Prevents Delete hi experts, I know this error means I have data in the other table that references the data I'm trying to delete but I don't know how to find the data. Thanks for any help. This is my code: …

Thanks, @mike01 I have not tried the Cascade option, just a bit afraid of it. I have tried deleting from the other table first and I get the same error on the same exact FK. I mapped out the FKs and their Dependency Levels. [image] Does this mapping help at all? Thanks again.

In this case, you might prefer to use SET NULL rather than CASCADE.

Need help interpreting FK error

SQL Server Administration

mike01 November 24, 2021, 5:10pm 2

Did you try any solutions from here?