title: MS Access Multiple Many-to-Many relationships
body: <p>I have one table "Liability" which is currently providing the available coverage amounts in a dropdown box.  It has the following fields:</p>
  
  <pre><code>[CoverageAmountID]
  [CoverageAmount]
  [Cost]
  [StateID]
  [ProductID]
  [CompanyID]
  </code></pre>
  
  <p>There are many coverage amounts, companies, states &amp; products.</p>
  
  <p>A complicated query currently pulls the correct Coverage Amount options.  My question is if I need to split this up and how?</p>
  
  <p>I have no relationships for this now but there are State, Product &amp; Company Tables.</p>
  
  <p>Do I create junction table with the CoverageAmountID, StateID, ProductID &amp; CompanyID as the primary key?</p>
  
  <p>Is there a better way to handle this with multiple m:m junction tables?</p>
  
  <p>I'm struggling with how this data should be structured.  The attached picture shows what I have in the table currently.</p>
  
  <p><img src="https://i.stack.imgur.com/oNCgE.jpg" alt="Liability Table"></p>