title: many to many relationships in ms access
body: <p>I have a database (for a pet sitting company) containing tables for the following:</p>
  
  <ul>
  <li>Customers</li>
  <li>emergency contacts</li>
  <li>phone numbers</li>
  <li>phone types</li>
  </ul>
  
  <p>The phone numbers are stored in a separate table to allow for efficient storage of a virtually unlimited number of phone numbers per customer. The phone numbers table stores both the customer ID and the phone type ID in addition to the primary key. My question is - is the best way to allow for emergency contacts to have the same functionality with phone number records to add another field to the phone numbers table "emergency contact ID"? Or should I be storing emergency contacts in the same table as customer (and rename it Individuals)? If so, please tell me how to create a relationship between records in the same table. </p>
  
  <p>Thanks so much, 
  Jessica </p>