SELECT COLLABORATORS.Surname AS DetailField1, COLLABORATORS.Prename AS DetailField2, COLLABORATORS.Personnel AS DetailField3, COLLABORATORS.Institute AS DetailField4, COLLABORATORS.Country AS DetailField5, COLLABORATORS.Comments AS DetailField6, COLLABORATORS.Keywords AS DetailField8, `COLLABORATORS`.`E-mail` as `DetailField7`, collaborators.* FROM COLLABORATORS WHERE COLLABORATORS.Personnel = #ID# SELECT PicturesMain.Entered, PicturesMain.PicName, PicturesMain.PicGenus, PicturesMain.PicSpecies, COUNTREF.PAESE, PicturesMain.locality, COUNTREF.Note, picturesmain.date, picturesmain.picturetype FROM PicturesMain LEFT JOIN COUNTREF ON PicturesMain.C_Code = COUNTREF.C_Code WHERE ( ((PicturesMain.Entered)=#ID#) AND ((PicturesMain.Scanned)=True) ) Collaborators - Detail
Collaborator

FishBase
 Name : #DetailField1#, #DetailField2#   -  (#replacenocase(collabtype," FB ", " FishBase ")#)
 Code No.: #DetailField3#
 E-Mail: #xdetailfield71# #xdetailfield71#  
 Web page : #s1#
 Fax : #fax#
 Institute : #DetailField4#
 Address : #number#, #street#, #city#  
 Country : #DetailField5#  
 Comments : #DetailField6#
 Keywords : #DetailField8#
 Since : #year#
 
Show all photo(s) [n=#allphoto.recordcount# ]
Glossary
Comments & Corrections 		  Sign our Guest Book