Hi,

Is it possible to show fields from a left join in the fieldlist of a ComplexTableField?

For example:

new ComplexTableField($this, 'ApplicationList', 'VacancyApplication', array(
                  'ID' => 'ID',
                  'AppDate' => 'Application Date',
                  'FirstName' => 'First name',
                  'Surname' => 'Surname'
                  
                  ),
                  $this->AppDetailFields()
                  , 'MyVacancyID = '.$id,
                  '',
                  'LEFT JOIN Member ON VacancyApplication.MyCandidateID = Member.ID'
                  )

I want to show the members FirstName and Surname in the list but it justs comes up blank.

Does anyone know how to make this work?

Thanks in advance