Many-to-Many Relationships

[Chantal]

I have set-up my tables and linking tables for many-to-
many relationships. I will be using drop-down menus in my
tables and linking tables. When I input the values in my
table drop-down menus, is there a way that the values can
automatically be copied into the linking tables so that I
don't have to input twice and also avoid typing errors.
If so, how do I do this?

Thanks for any help?

 

[Roger Carlson]

You should not be working directly in your tables. You should be using
forms for this. Access has a subform control that takes care of putting the
foreign key into the table on the "one-side" of a one-to-many relationship.
This is tremendously helpful.

This same method can be used with a Many-to-Many relationship by making the
form base on one table and the subform base on a JOIN of the other two.

On my website is a small sample database called:
"ImplementingM2MRelationship.mdb" which illustrates a couple of ways to use
forms with a M2M relationship.