title: MS Access: lookup values for string-based multi-value field
body: <p>Here is my situation:</p>
  
  <ul>
  <li>linked table (so I can't actually modify the column config) has a column with a comma-separated list of values. this is a text string -- not a true multi-value field.</li>
  <li>I need to map those values to a lookup table and return a comma-separated list using the lookup values</li>
  </ul>
  
  <p>So let's say a row has the values: A,B,C in this column. The mapping table maps: A|1, B|2, C|3. The resulting column in my query should list 1,2,3 (the mapped values).</p>
  
  <p>I can add a column in my query, indicate the display control is combo box (which is what you would typically do for a multi-value field), select my row source, and bind the columns -- but only rows with a single option value will map correctly. If it has a comma-separated list, per the above example, it does not map the values. How would I go about this mapping?</p>