1 Topic by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 262

Topic: Linking from report to taxon occurence

I have an xml report that shows the taxon occurrence key for each record, but can't get it to go to that taxon occurrence by clicking on the key, as you can from the report wizard. The column is included as
    <Column name="Taxon_Occurrence_Key" keycolumn="Taxon_Occurrence_Key" visible="true" />
and the error message is
    qryCustomReport: Field " not found.
What am I doing wrong?

Janet Simkin
British Lichen Society

Janet Simkin's Website

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,391

Re: Linking from report to taxon occurence

I think you need to add the tablename: 

<Column name="Taxon_Occurrence_Key" keycolumn="Taxon_Occurrence_Key" tablename="Taxon_Occurrence" visible="true" />
Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 262

Re: Linking from report to taxon occurence

So easy when you know how! Thanks.

Janet Simkin
British Lichen Society

Janet Simkin's Website