title: How to implement multi-select?
body: <p>First of all, I need to say that I never worked with Access or any other databases before. I'm trying to understand how it works and picked "Students" template for this task (see step 0). Now, let's start.</p>
  
  <h1>i. Creating the base from the template and fill it with data</h1>
  
  <p><strong>Step 0</strong>. Creating new database based on "Students" template:</p>
  
  <p><a href="https://i.stack.imgur.com/9753J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9753J.png" alt="enter image description here"></a></p>
  
  <p><strong>Step 1</strong>. On the objects pane (i.e. left sidebar) search for <em>Student List</em> form and double-click on it:</p>
  
  <p><a href="https://i.stack.imgur.com/B9P86.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B9P86.png" alt="enter image description here"></a></p>
  
  <p>Fill the <em>First Name</em> and <em>Last Name</em> for the first student: it will be Mike Smith.</p>
  
  <p>In the <em>Special Circumstances</em> column it is possible to select <strong>multiple</strong> circumstances: for example, <em>Circumstance 1</em> and <em>Circumstance 2</em>. And if you click on the icon below the combo-box, it is possible to edit the list of available check-boxes:</p>
  
  <p><a href="https://i.stack.imgur.com/Krbun.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Krbun.png" alt="enter image description here"></a></p>
  
  <p><strong>Step 2</strong>. After we have created the entry for the first student, double-click on the <em>Guardian List</em> form and create entries for 3 guardians: Jane Roe, John Doe and Jill Joe.</p>
  
  <p><strong>Step 3</strong>. Return to the <em>Student List</em> form. Click on the <em>Open</em> cell in front of <em>Mike Smith</em>. It will be opened <em>Student details</em> form for this student. When it will be opened, click on <em>Guardian Information</em> tab - and you will see, that all 3 guardians are available for combo-box:</p>
  
  <p><a href="https://i.stack.imgur.com/rLcHD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rLcHD.png" alt="enter image description here"></a></p>
  
  <h1>ii. Now, my task</h1>
  
  <ul>
  <li><p>I want to see the guardians directly in the <em>Student List</em> form - the same way as <em>Special Circumstances</em> located.</p></li>
  <li><p>I want to get the option to select multiple guardians for each student - the same way as <em>Special Circumstances</em> check-boxes are implemented.</p></li>
  </ul>
  
  <h1>iii. How it was solved myself, but only the 1st point of the task</h1>
  
  <p>To simplify the task, I will use <em>Student ID</em> column (located on the <em>Student List</em> form), instead of creating new column.</p>
  
  <p>On the left sidebar - click on <em>Student List</em> form with right mouse button and then select <em>Design View</em>. When <em>Design View</em> will be opened, select <em>Student ID</em> field, right click on it, then click <em>Change To</em> and <em>Combo Box</em>:</p>
  
  <p><a href="https://i.stack.imgur.com/Tpek8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tpek8.png" alt="enter image description here"></a></p>
  
  <p>Then, on the right sidebar select <em>Data</em> tab, set curson inside <em>Row Source</em> field and then click small ellipsis (...). In the <em>Show Table</em> window select <em>Guardians</em> and then click <em>Add</em> button and close this small window.</p>
  
  <p><a href="https://i.stack.imgur.com/FSjRC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FSjRC.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/7182m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7182m.png" alt="enter image description here"></a></p>
  
  <p>Then, in the large window, do this:</p>
  
  <p><a href="https://i.stack.imgur.com/wcYF6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wcYF6.png" alt="enter image description here"></a></p>
  
  <p>And then click <em>Save As</em> and <em>Close</em> on the ribbon.</p>
  
  <p>Then, switch the <em>Student List</em> form back to the <em>Layout view</em> (the same way, as we switched it early to <em>Design View</em>). And you will see that the first point of my task is solved: the last names of guardians are available in <em>Student ID</em> column:</p>
  
  <p><a href="https://i.stack.imgur.com/ZG6Ts.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZG6Ts.png" alt="enter image description here"></a></p>
  
  <p>But how I can implement multiselect, the same way as it is implemented in <em>Special Circumstances</em> column? So, Mike could have both Jane Roe and John Doe as his guardians.</p>