title: CakePHP form select value as table.id, select option text as table.textfield
body: <p>I'm new to Cake. I've gotten some things set up, relevantly a "users" and a "profiles" table, controller, model and view. In my <code>profiles/add</code> view, I'm attempting to output a <code>select</code> input with the value being the <code>user.id</code> and the option text being the <code>user.username</code>. Ultimately, the value <code>user.id</code> will be saved in <code>profile.user_id</code>.</p>
  
  <p>I have read through a lot of documentation, and successfully set up the <code>select</code> to output the options from the <code>user</code> tables, but it uses the <code>user.id</code> as both the value and the option text.</p>
  
  <p>Controller:</p>
  
  <pre><code>    $this-&gt;set('users', $this-&gt;Profile-&gt;User-&gt;find('list'));
  </code></pre>
  
  <p>View: </p>
  
  <pre><code>    echo $this-&gt;Form-&gt;input('user_id');
  </code></pre>
  
  <p>It seems like this sort of thing would be routine, so feel free to answer with just a link to the documentation if I've overlooked it completely.</p>
  
  <p>Thanks!</p>