title: creating relational tables within a database
body: <p>I am having a major issue with relating the following tables together. It is a many to many relationship between Patient and Nurse. </p>
  
  <p>Here is the relational table:</p>
  
  <pre><code>Patient (PatientID (PK), Forename, surname, gender, date of birth, address, illness, prioirty)
  
  seen_by (ID(PK) PatientID(FK to Patient.PatientID), NurseID(FK to Nurse.NurseID) )
  
  Nurse (NurseID(PK), Forename, surname)
  </code></pre>
  
  <p>The issue I am getting is that, I want the PatientId to be assigned to a NurseID so I know what patient is seen by what nurse. Please note that the ID are all auto_increment values. </p>
  
  <p>Any suggesions, thanks in advance!</p>