I wondered whether you meant taxon occurrences without determinations – effectively a database corruption or referential integrity problem. If so, the following XML report will find them. Other corruptions I have seen in Recorder 2002 databases are taxon determinations with no Taxon_list_item keys, taxon occurrences with no preferred determinations and taxon occurrences with more than one preferred determination. If problems occur it is worth checking for these. If a taxon occurrence doesn’t have a taxon determination or a determination doesn’t have a valid Taxon_list_item key then you can’t see the occurrence in the observation hierarchy because there is no species name to display.
<?xml version="1.0" ?>
<CustomReport title="Taxon occurrences without determinations" menupath="Database checks" description="Returns a list of taxon occurrences which do not have determinations.">
<SQL>
SELECT
TAXON_OCCURRENCE.TAXON_OCCURRENCE_KEY
FROM TAXON_OCCURRENCE LEFT JOIN TAXON_DETERMINATION ON TAXON_OCCURRENCE.TAXON_OCCURRENCE_KEY = TAXON_DETERMINATION.TAXON_OCCURRENCE_KEY
<Where keytype="Default">
WHERE
(TAXON_DETERMINATION.TAXON_DETERMINATION_KEY) Is Null
</Where>
</SQL>
<Columns>
</Columns>
</CustomReport>
Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687