G
Guest
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?
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?