title: CakePHP update two table in same time
body: <p>Hi I'm working on a project for a nightclub system. Our client wants to have an electronic sign in page at events, where he can sign in patrons automatically into the database. At the same time, he wants to be able to identify which patrons attended which events. In our database we've accommodated this by using a "Guestlist" table that joins an event ID (event) with a patron ID.</p>
  
  <p>My interpretations of event-flow at this moment is:</p>
  
  <ul>
  <li><p>A patron comes to the counter and gives info to be enterred into database.</p></li>
  <li><p>Info is submitted and goes into the Patron Table, generating a patron ID.</p></li>
  <li><p>The Guest list table for said event then gets the patron ID and the event ID of the event, both referenced from respective tables, and joins the tables.</p></li>
  <li><p>from the guest list table the user can view the events ID and patron info that was submitted.</p></li>
  </ul>
  
  <p>I'm not sure whether I've missed a step or if our database is incomplete/incorrect but we have no idea how to procceed with this in cakePHP.</p>