|Please consider donating $1 per sample downloaded, (find out why here)|
Joined: 20 Feb 2008
Posted: 10 Apr 2009 at 3:43am
Please consider donating $1 per sample downloaded, find out why here.
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.
To run the code, open Module1, place the cursor in the subroutine, and click Run.
Access 2000-2003 version: ParseMultivalueFieldToNormalizedStructure.zip
Level: Intermediate. Requires knowledge of VBA programming.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum