Lindsay,

We had the same problem and you managed to get the information on how to implement TVK in Report Wizard from Mark Pollitt. Can you connect to the linked Access database. If you can then I can send you details of how to do it.

Charlie

Scottish Wildlife Trust

Hi Lindsay

Yes, there is a way to do it in the R6 report wizard (I've just tried it and it works). You'll need to add an entry into two of the tables in the SQL Server database (using either SQL Server Management Studio or the linked MS Access database). The first is the REPORT_ATTRIBUTE table which defines where the field value will come from (the INDEX_TAXON_NAME table in this case) and the second is the REPORT_FIELD table which I assume defines which fields appear in the report wizard (and links to the new REPORT_ATTRIBUTE entry).

I've attached a spreadsheet containing examples of the values to add - there are two entries in each tab, one for the TVK of the recorded taxon and the other is the TVK of the recommended taxon. It should work if you just copy and paste the records into the tables but you could edit the key fields in columns A and A + B respectively) if you want to reference your own custodian key.

I hope this all makes sense - if not let me know.

Regards
Andy