title: Add Relationship for Columns with different data Types
body: <p>I have 2 table in my database , master table have a field named "ID" with "uniqueidentifier" data-type , Detail table have a field named "MID" with "nvarchar" Data-Type that I store Master table field "ID" value in it</p>
  
  <p>I want to add a master-detail relationship between these tables but when i want to do , a message says : " The Following data types properties of column "..." do not match column those of "..." "</p>
  
  <p>it`s not possible that i set "MID" data-type to "uniquidentifier" !</p>
  
  <p>in MS-Access it`s possible to do , but how can i do this in MS-SQLServer 2008 ?!</p>
  
  <p>thanks before ...</p>