Topic: Taxon designation
I did a search for my question, but couldn't find the answer on the forum so far:
I try to extract records from Recorder, which are designated using an Access database linked to the Recorder database. Now I came accross some species, where the desgnation, which I see in my query in Access is not visible in Recorder and which should not be in Recorder. I wonder, how that can happen?
For my query I'm using the index tables, which I have rebuilt directly before running the query.
My query for one of the species, which shows a designation in the query but not in Recorder, is here:
SELECT Index_Taxon_Designation.Taxon_Designation_Type_Key, INDEX_TAXON_NAME.ACTUAL_NAME
FROM INDEX_TAXON_NAME INNER JOIN Index_Taxon_Designation ON INDEX_TAXON_NAME.TAXON_LIST_ITEM_KEY = Index_Taxon_Designation.Taxon_List_Item_Key
WHERE (((INDEX_TAXON_NAME.ACTUAL_NAME)="Onobrychis viciifolia subsp. collina"));
It actually has the two same designations as the parent species (Onobrychis viciifolia). One of the designations is the one I entered myself for Onobrychis viciifolia (English Red List of plants). The other designation is supplied by the system.
IT recently moved the database to another SQL Server. IT told me the new place and I have a ODBC-connection set up to that place. Unfortunately I can't check in Recorder, if it really gets the data from the same place, or is there a way?
What am I doing wrong?
It would be great, if somebdoy could help me please.