title: ColdFusion 10 ORM. How to customize EntityLoad return with 2 many-to-many tables?
body: <p>I have 3 tables</p>
  
  <p><strong>Users</strong></p>
  
  <ul>
  <li>users_pk</li>
  <li>userName</li>
  </ul>
  
  <p><strong>Users_Settings</strong></p>
  
  <ul>
  <li>users_settings_pk</li>
  <li>users_fk</li>
  <li>settings_fk</li>
  <li>value</li>
  </ul>
  
  <p><strong>Settings</strong></p>
  
  <ul>
  <li>settings_pk</li>
  <li>settingName</li>
  <li>valueList</li>
  </ul>
  
  <p><strong>Users</strong> has a <em>one-to-many</em> relationship to <strong>Users_Settings</strong><br>
  <strong>Settings</strong> has a <em>one-to-many</em> relationship to <strong>Users_Settings</strong><br></p>
  
  <p><strong>Users_Settings</strong> has a <em>many-to-one</em> relationship to <strong>Users</strong><br>
  <strong>Users_Settings</strong> has a <em>many-to-one</em> relationship to <strong>Settings</strong></p>
  
  <p>How would I use EntityLoad to get all the settings.name and associated users_settings.value for a specific user? </p>
  
  <p>My current solution is to make a custom query or use cfquery but was wondering if there is a way using coldfusion ORM. </p>