I have yet another FK error issue when I try to delete.
The DELETE statement conflicted with the REFERENCE constraint "FK_tblRFISummary_tblRFIQuestion_tblID". The conflict occurred in table "dbo.tblRFIQuestions", column 'tblID'.
tblRFIQuestions has a FK on tblID in tblRFISummary:
ALTER TABLE [dbo].[tblRFIQuestions] WITH CHECK ADD CONSTRAINT [FK_tblRFISummary_tblRFIQuestion_tblID] FOREIGN KEY([tblID])
REFERENCES [dbo].[tblRFISummary] ([tblID])
ALTER TABLE [dbo].[tblRFIQuestions] CHECK CONSTRAINT [FK_tblRFISummary_tblRFIQuestion_tblID]
Interestingly, I get the error on tblRFISummary whether I delete it before or after deleting from tblRFI Questions.
Any tips will be greatly appreciated. (No I haven't tried the CASCADE option)