Hello, I solved the problem now as follows *JobsController.php* ... $drivers = $this->Job->query("SELECT User.id, (CONCAT(vorname, ' ',nachname)) AS name FROM users AS User INNER JOIN users_events AS Event ON User.id = Event.user_id WHERE Event.event_id = $jobid"); ...
*edit.ctp* $select_value = array(); $select_value[null] = '-- Make a selection --'; foreach($drivers as $driver) { $key = $driver['User']['id']; $value = $driver[0]['name']; $select_value[$key] = $value; } $mydata = $this->data; if ( $mydata['Job']['driver_id'] != null ) { foreach ( $select_value as $k => $v ) { if ( $mydata['Job']['driver_id'] == $k ) { $this_is_selected = $k; } } } else { $this_is_selected = 0; } echo $this->Form->input('driver_id', array( 'options' => $select_value, 'type' => 'select', 'label' => 'Driver' )); *add.ctp* $select_value = array(); $select_value[null] = '-- Make a selection --'; foreach($drivers as $driver) { $key = $driver['User']['id']; $value = $driver[0]['name']; $select_value[$key] = $value; } echo $this->Form->input('driver_id', array( 'options' => $select_value, 'type' => 'select', 'label' => 'Driver' )); Okay it's not CakeLike, but it works flawlessly. Nice Greetings -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.