title: How to store multiple textbox values of different classification into one table?
body: <p>Please refer this picture :<br>
  <img src="https://i.stack.imgur.com/zvlAY.png" alt="FormUI"></p>
  
  <p>So, I've made a form consisting 11x3 textboxes for 11 machines. One machine has 3 textboxes of parameters. </p>
  
  <p>My table is named TOSA_settings and the fields are as below:<br>
  UCL<br>
  LCL<br>
  mean<br>
  machine</p>
  
  <p>I've disabled all textboxes because user shall be able to edit/update any machine that they ONLY want to update. If user want to update machine 1, he will click on edit label at the right side of TOSA 01 textboxes and the textboxes will be enabled=true. User can fill in data then save only for that particular machine. Where the rest will remain disabled. </p>
  
  <p>Now, i only try coding for two machine to see if it works.</p>
  
  <p>Thus, I wrote the code as this under cmdSave_Click()</p>
  
  <pre><code>Dim strSQL As String
  
  If mean1.Value &lt;&gt; "" Then
      strSQL = "INSERT INTO TOSA_settings( UCL, LCL, mean, machine) VALUES (" &amp; Me.UCL1 &amp; "," &amp; Me.LCL1 &amp; ", " &amp; Me.mean1 &amp; ", 'TOSA 01');"
  End If
  If mean2.Value &lt;&gt; "" Then
      strSQL = "INSERT INTO TOSA_settings( UCL, LCL, mean, machine) VALUES (" &amp; Me.UCL2 &amp; "," &amp; Me.LCL2 &amp; ", " &amp; Me.mean2 &amp; ", 'TOSA 02');"
  End If
  CurrentDb.Execute strSQL, dbFailOnEror
  </code></pre>
  
  <p>But it only save the values from TOSA 02. 
  or should I create other tables, one machine each?</p>