title: how do i create this association
body: <p>i have the following 2 sql server tables</p>
  
  <pre><code>Products
  locationCode (PK), prodId (PK), productName
  ---------------------------------
  AUG, 1, Widget
  ATL, 1, Widget
  
  Categories
  prodId (PK) catId (PK), catName
  ----------------------------------
  1, 1, WidgetsCategory
  1, 1, WidgetsCategory
  </code></pre>
  
  <p>What would I need to do to create an association where a single product can have many categories given the required fields and (PK) Primary keys?</p>