Topic: Error with Create new determination based on spreadsheet batch update
I'm trying to run the above batch update on a set of records but when I do, this message keeps appearing.
There is an error in the SQL code. The error message is: 'The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TAXON_DETERMINATION_TAXON_OCCURRENCE". The conflict occurred in database "NBNData", table "dbo.TAXON_OCCURRENCE", column 'TAXON_OCCURRENCE_KEY"
I ran the batch update on a different set of records prior to this and it worked perfectly. Any ideas?
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre