Many-to-many forms

[WoodyAccess]

I have created a many to many table with fields Products and Agents. I want
to put this into a subform and into my main Products Form (one of it many
realtionships). How can I link the product control for the main and subform
so that only the agents information from the agents muliple selection list
box is seen but it will automatically update the table with the the
information for both product and agent?

Product Agent
1 1
1 2
1 7
2 3
3 5
3 7

Or is there any other way around it! I hope this makes sense?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship.mdb" which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L