I have inherited a database written in Access 2010 that has MVF fields in several of the tables. I would like to remove the MVF fields and go back to a many to many relationship with a junction table. I am not very experienced with VBA yet. Is there a way to loop through the records and write a record with the key and each instance of the mutlivalue in individual records? Here is an example of two of the table definitions:
tblContact
Contact_ID, autonumber
Last_Name
First_Name
Team_Lookup, number (MVF) Combo box display control
tblTeam
Team_ID, autonumber
Team_Name
Thank you for any guidance you can give me.