title: DatGridView table to a new Table in Access 2013
body: <p>I have a DataGridView that receives 3 columns (Bound) from a Table in an Access database.
  There are 5 other columns that are Unbound and after making changes.</p>
  
  <p>Here are is the datagridview</p>
  
  <pre><code>ID (Bound from xsd file)
  First name (Bound from xsd file)
  Last Name (Bound from xsd file)
  Active (Bound from xsd file)
  Monday
  Tuesday
  Wednesday
  Thursday
  Friday
  </code></pre>
  
  <p>I want to save the following to another table called <strong>WeeklySchedule</strong> (or update the table with values from the datagrid)[would also be nice to load the data from WeeklySchedule if it's there]</p>
  
  <pre><code>ID
  Monday
  Tuesday
  Wednesday
  Thursday
  Friday
  </code></pre>
  
  <p>So when I update the table by selecting the checkbox (Monday->Friday) and click on a button</p>
  
  <p>I want to update the table <strong><em>WeeklySchedule</em></strong> with those values for the ID in the same row.</p>
  
  <p>Example</p>
  
  <p>row 1 and 2 have the following data</p>
  
  <pre><code> POID  FIRSTNAME  LASTNAME  ACTIVETODAY  MONDAY  TUESDAY WEDNESDAY THURSDAY FRIDAY
    1     JOHN       SMITH      X            X       _        _        X        X
    2     JASON      SMITH      _            X       X        _        X        X
  </code></pre>
  
  <p>In the first table, I want to save the "ActiveToday" state (if it changed)</p>
  
  <p>In the second table, I want to update/insert the schedule M-F     </p>
  
  <p>If my approach is wrong or I am overthinking the solution. Please let me know</p>