title: Automatic Insert to Another Table
body: <p>i'm working on a certain system that evaluates the performance of teachers.</p>
  
  <p>Table 1: </p>
  
  <pre><code>Student (student_id,student_name,teachers,subjects)
  </code></pre>
  
  <p>Table 2: </p>
  
  <pre><code>Teacher (teacher id, teacher_name, subjects)
  </code></pre>
  
  <p>Is it possible that i can automatically insert some of data in the columns of Table 2 while inserting to the Table 1, by just one script? And can reference such that everytime a student login, he already knows who will he/she evaluates based on the subjects enrolled of the student and the teacher teaches. Did I make sense? Hoping for your response! Thanks Guys!</p>