Topic: Problem deleting records
Please can someone help me?
I have some records that were imported years ago from a standalone copy of Recorder into our network one.
An error happened either at export from standalone or at the import and events and field observations and taxa occurrences were muddled up.
So I cleared them one by one, deleting the erroneous taxa. The records are now in Recorder at event level only but when I try to delete these events one by one I get the message: "The record cannot be deleted because it has records linked to it."
When I try to delete the whole survey of these records via using the batch update JNCCDel5Records I get the message: "There is an error in the SQL code. The error message is: "The DELETE statement conflicted with the REFERENCE constraint "FK_SAMPLE_RECORDER_SURVEY_EVENT_RECORDER". The conflict occured in database "NBNData", table "dbo.SAMPLE_RECORDER", column "SE_RECORDER_KEY".
Any thoughts please?