title: Dynamics CRM 2011 creating relationships between custom entities
body: <p>I have defined 3 entities in MSCRM 2011.      </p>
  
  <p><strong>1-Place</strong>: This is the main entity. In this form I have some fields (let say IDs, Whole Number) that I want to create some relationships with other custom entities.<br>
  <strong>2-Category</strong>: This has two fields, ID(Whole number) and Category Name(text.) This is simply a relation entitiy.<br>
  <strong>3-Place-Category Relationship</strong>: This entity contains relationships between Category and Place. It has two main arguments, both of them are whole number.</p>
  
  <p>One place can have more than one Category.</p>
  
  <p>I want to display end user Place and the categories related to to that place entity.</p>
  
  <p>Thanks in advance.</p>
  
  <hr>
  
  <p>More info about this question:<br>
  - In <em>Place</em> entity each Place has a unique ID (1 = Train Station, 2 = Jhon's Kebab House, 3 = Nando's, 4 = Wagamama ...)<br>
  - In <em>Place</em> entity I have plenty of data but Category IDs are used to match places with categories (like 42, 108 etc.)<br>
  - In <em>Category</em> entity I have two fields. Category ID's matched with their category names (1 = Cafe, 2 = Restaurant ... 42 = Train Station, ... 108 = Grocery etc.)<br>
  - In <em>Place-Category Relationship</em> entity I have IDs of the places and the IDs for the cateories.(like PlaceID = 1 CategoryID =42, PlaceID = 2 CategoryID = 2, PlaceID = 2 CategoryID = 5 ..etc)  </p>
  
  <p>There are 140K Places, 200 Categories and more than 400K Place-Category Relationship.</p>
  
  <p>One place has at least one, maximum 80 categories.  </p>
  
  <p>I want to match all my Places with their Categories entity (by aid of <em>Place-Category Relationship</em> entity).  </p>
  
  <p>I want to automate this matching process.</p>