This will require some investigation in the tables. The error you  get on the Goto suggests to me that you may  not have lost the species, just something they need to display.  When you say the Goto key gives an error what table are you searching on ?

Hi Mike,

Further info:

Have found the complete record (1 of 60) in an old copy of Recorder. It is Heriades truncorum, which appears 10 times in the Index_Taxon_Name table, all with a preffered key of 'NHMSYS0000872382'. In our Live system and the stand alone system where the problem was first notice, it only appears 9 times. The missing one has a taxon_list_item_key of 'NHMSYS0020437062' which is the one allocated to the record with the missing species.

Hope that makes sense. I don't know if it indicates that we have a problem, but hopefilly it will give you more of a lead.

Cheers,

Dave

Hi Rob,

Thanks for the suggestion, but that was the first thing we tried. No joy.

I've run a query today and we have 67 determinations (out of 3,175,352) where the list_item_key doesn't appear the index_taxon_name table. Confusing.

Cheers,

Dave

Hi Mike,

I've just checked and as you say, all the TLIK's are in the Taxon_List_Item table. I've attached a spreadsheet of the keys.
We only found the problem by accident when we extracted some records and one had no species. Further investigation showed 67 records.

Cheers,

Dave

Although you can't now use these for input, it shouldn't cause any problem.  I think one of the associated dictionary tables  could be missing data for these taxa. I suspect that it could be Taxon_Common_Name.  If they are missing from there it would stop  them going into Index_Taxon_name. Could you check this out please.