title: What is the best way to implement many-to-many relationships using ORMLite?
body: <p>I'm currently playing with ORMlite to make a model with tables and relationships.
  One relationship is a many-to-many relationship. What's the best way to implement that?</p>
  
  <p>To be more concrete:</p>
  
  <p>Let's say I've got these two tables</p>
  
  <pre><code>Product
     id
     brand
  
  Purchase
     id
  </code></pre>
  
  <p>A purchase can have several products and one products can be in several purchases.
  Using ORMLite I could have a <code>@ForeignCollectionField</code> in each model but I don't think it would work.
  The only valid solution I see is to make a third table Product_Purchase to link Product and Purchase with many-to-one relationships.</p>
  
  <p>What do you folks think?</p>