The Many-to-Many Add-In provides a way for developers to quickly and easily create forms that can be used to populate the junction table of a many-to-many table relationship. Normally, populating a junction table requires use of a Main-Form/Sub-Form interface with the junction table being populated by a Combo Box which is in the Sub-Form. (Don't know what I am talking about? Click
HERE.) This kind of interface is extremely "kludgy" but it the only option available to non-programmers (unless they use some kind of Add-In such as the one described here.)
You start the Many-To-Many wizards (there are two of them) by selecting either Tools/Add-Ins/M2M CheckBox Wizard or Tools/Add-Ins/M2M ListBox Wizard from the menu. Each of these will step you through a wizard that will create a form for you (that you name at the end) that can then be used to populate the junction table with an form that is easy to use and intuitive. (NOTE: These wizards are the least tested of all of them and you probably WILL find bugs.)
For more information the Many-to-Many wizards or table relationships in general please click here or read the help file that is distributed with the wizards.
To view/download the tools you must be a registered user. If you are registered user you will see a hyperlink to the downloads page below. Otherwise, register on the site and come back to this page.