Bob

Name_key in survey event recorder with a link to the individual table to get the actual name does hold the recorders for a survey event, but there is bit more to the structure than this. Survey_Events can have mutiple Recorders so Survey_Event_Recorder holds mutiple entries for one event. Table Sample_Recorder identifies which of the recorders in Survey_Event_Recorder apply to a particular sample (minimum one)

The report wizard  uses the User Defined Function  dbo.FormatEventRecorders which despite its name, takes the sample key and returns the recorders for the sample as a  comma separted string.

Mike

The problem is that there can be mutiple recorders for a record. This makes the structure for getting at the recorder fairly complex. To filter on a recorder (observer, collector etc.) you would need to link sample (the actual record), sample recorder, survey event recorder and individual and look for the elements you want to filter on (eg Title, initials, forename, surname) in the individuals table.

Mike