title: Laravel 4: Keeping a table Relationship when reducing structure into several tables
body: <p>History:</p>
  
  <p>DB: Tables clients and titles</p>
  
  <p>A Client can have many titles but a title can only have one client. So i will use a simple one-to-many relationship as illustrated below:
  Client Model</p>
  
  <pre><code>  class Client extends Eloquent {
        public function titles(){
            return $this-&gt;hasMany('titles');
        }  
    }
  </code></pre>
  
  <p>Then i simply use the following to get the requested data for the selected title</p>
  
  <pre><code>  $clientTitles = Client::find(1)-&gt;titles;
  </code></pre>
  
  <p>All in all this should list all client associated titles.</p>
  
  <p>My question really comes to this as i am looking to split my data within my titles table into smaller tables as i also use some aspects of the titles data somewhere within the system and do not need to get all of the title details every time.</p>
  
  <p>So i would have another three tables related to the titles data table</p>
  
  <p><strong>Titles, Title_Artwork, Title_Details, Titles_List</strong></p>
  
  <p>Now if i use the same as above i will get all the data within the titles table, but not the other three.  So how can i then update my relationship to then scrape the other three title tables so when i need to, i can get all the data, rather. </p>
  
  <p>Or is there another way to do this or NO keep to what i have done an just limit the call to the fields i require?</p>