{sql:select * from her_project
 WHERE her_project.rowid = @File number@
}

Dyfed Archaeological Trust, Corner House, 6 Carmarthen Street, Llandeilo, Carmarthenshire, SA19 6AE
Tel (01558) 823131, Email info@dyfedarchaeology.org.uk

{subtable:
SELECT cat_archive.ern,

ifnull(cat_archive.project_title,' ') as P1,

ifnull(cat_archive.related_prns,' ') as rel_1,

ifnull(cat_archive.related_nprns,' ') as rel_2,

ifnull(cat_archive.related_sms,' ') as rel_3,

ifnull(cat_archive.related_lbs,' ') as rel_4,

ifnull(cat_archive.other_ref_nos,' ') as rel_5,

ngr,

site_name_and_address,

ifnull(cat_archive.site_types,' ') as type_1,

ifnull(cat_archive.project_types,' ') as type_2,

client,

project_manager,

project_date,

categories_present,

location_digital as location1,

accession_no as accession1,

copyright_digital as copyright1,

access_restrictions as access1,

paper_location as location2,

accession_no_paper as accession2,

copyright_paper_archive as copyright2,

paper_access_restriction as access2,

location_finds as location3,

accession_no_finds as accession3,

copyright_finds_archive as copyright3,

access_restrictions_finds as access3

FROM cat_archive

JOIN her_archive_link on cat_archive.ern=her_archive_link.ern

WHERE her_archive_link.fileno=[rowid]

 group by cat_archive.ern;

title::[b]ERN[/b] ,prn,  [br][b]Project Title:[/b] , P1 , [br][b]Related PRNs[/b] ,rel_1, [br] [b]Related NPRNs:[/b] , rel_2, [br][b]Related SM Nos:[/b] , rel_3 ,  [br][b]Related LB Nos:[/B] ,rel_4, [br][b]Other Related ref Nos:[/B] ,rel_5, [br][b]NGR[/b] ,ngr, [br][b]Site Name and Address[/b] ,site_name_and_address, [br][b]Site type/s:[/b] ,type_1, [br][b]Project type/s[/b] ,type_2 , [br][b]Client:[/b] ,client , [br][b]Project Manager:[/B] ,project_manager2, [br][b]Project dates:[/b] ,project_date, [br][b]Categories present from archive index:[/b] ,categories_present, [br][b]Location of digital archive:[/b] ,location1, [br][b]Accession No of digital archive:[/b] ,accession1, [br][b]Copyright of digital archive:[/b] ,copyright1, [br][b]Restrictions on access to digital archive:[/b] ,access1, [br][b]Location of paper archive:[/b] ,location2, [br][b]Accession No of paper archive:[/b] ,accession2, [br][b]Copyright of paper archive:[/b] ,copyright2, [br][b]Restrictions on access to paper archive:[/b] ,access2, [br][b]Location of finds archive:[/b] ,location3, [br][b]Accession No of finds  archive:[/b] ,accession3, [br][b]Copyright of finds archive:[/b] ,copyright3, [br][b]Restrictions on access to finds archive:[/b] ,access3, }