title: Association between two tables where keys are different data types
body: <p><strong>Tables</strong>  </p>
  
  <ul>
  <li>Departments  </li>
  <li>Employees</li>
  </ul>
  
  <p>I'm trying to associate:  </p>
  
  <ul>
  <li>Departments - dept_code : char(4)   </li>
  <li>Employees - dept : varchar(4)</li>
  </ul>
  
  <p>But I receive the following error,  </p>
  
  <blockquote>
    <p>Error 2039: The conceptual side
    property 'DEPT_CODE' has already been
    mapped to a storage property with type
    'char'. If the conceptual side
    property is mapped to multiple
    properties in the storage model, make
    sure that all the properties in the
    storage model have the same type.</p>
  </blockquote>
  
  <p>Other than changing the field's data type on the database side... Is there are workaround to this?</p>