title: Alternative to multi-valued fields in MS Access
body: <p>Related question: <a href="https://stackoverflow.com/questions/1461582/multivalued-fields-a-good-idea">Multivalued Fields a Good Idea?</a></p>
  
  <p>I know that multi-valued fields are similar to many-to-many relationship. What is the best way to replace multi-valued fields in an MS Access application? 
  I have an application that has multi-valued fields. I am not sure how exactly to do away with those and implement exactly same logic in the form of fields that are single-valued?</p>
  
  <p>What would be the implementation in terms of table-relationships when I want to move a multi-valued relationship to single-valued one.</p>
  
  <p>Thank you.</p>