Parse Multivalue Field To Normalized Structure.mdb
by Roger Carlson
This sample illustrates how to write values from a multiple valued field (not the Access 2007 multi-value field) into a normalized Many-to-Many structure. The original table is called "ContactsDownloadMultivalue". The contact information is written into "tblContacts". The category information from the multiple valued field is written to "tblCategories".
Then a record is created in jtblContactCategory junction table, establishing the many-to-many relationship.
You can find the sample here: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=449