Hi everyone

I want to get some data from a related table to show in the result set of ComplexTableField

$tablefield = new ComplexTableField(
                 $this,
                 'Results',
                 'Result',
                 array(
                 'PositionFinished' => 'Position Finished',
                 'PointedScored' => 'Pointed Scored',
                 'CarNumber' => 'Car Number'
                 ),
                 'getCMSFields_forPopup'
             );
            $fields->addFieldToTab("Root.Content.Result Manager",$tablefield);

CarNumber exists in the table "Teams", the other fields exists in "Results". However its not displaying the correct data.

The below is the set up with results class...

static $has_one = array (
            'Event' => 'Event',
            'Team' => 'Team',
            'Season' => 'Season'
        );

and the event has many results. Any ideas why this wouldnt appear?

Cheers

You can use dot notation inyour objects summaryfields. So I think this might work:

$tablefield = new ComplexTableField(
$this,
'Results',
'Result',
array(
'PositionFinished' => 'Position Finished',
'PointedScored' => 'Pointed Scored',
'Team.CarNumber' => 'Car Number'
),
'getCMSFields_forPopup'
);
$fields->addFieldToTab("Root.Content.Result Manager",$tablefield);

D'oh! Of course.... thanks :)