title: Using MySQL 1 to many relationship
body: <p>I currently don't have any code yet. I understand what a 1 to many joined relationship is I just don't know how to make it work. The idea here is that many carriers can have the product and vice versa. How can I keep track of which carriers has which products if each table has only 1 field to keep the others ID in? Here's the example:</p>
  
  <h2>Table: Carriers</h2>
  
  <ul>
  <li>id </li>
  <li>name</li>
  <li>productID</li>
  </ul>
  
  <h2>Table: Product</h2>
  
  <ul>
  <li>id </li>
  <li>name</li>
  <li>description</li>
  <li>carrierID</li>
  </ul>