Creating forms that populate many to many relationships

Would someone out there be able to share with me how to create forms that are populated from other tables that are related by two many-to-many relationships?

Thanks for any and all of your suggestions.

You need a 3rd table between the other two, to resolve the many-to-many into
a pair of one-to many relations.

Then create a main form into one of the main tables, with a subform into the
junction table.

For an example, see:
http://allenbrowne.com/casu-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"tbride" wrote in message
news
Would someone out there be able to share with me how to create forms that
are populated from other tables that are related by two many-to-many
relationships?

Thanks for any and all of your suggestions.

Allen: I have one more question... do you have an email that I could discuss my issue with you? I may be reashed at

----- Allen Browne wrote: -----

You need a 3rd table between the other two, to resolve the many-to-many into
a pair of one-to many relations.

Then create a main form into one of the main tables, with a subform into the
junction table.

For an example, see:
http://allenbrowne.com/casu-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"tbride" wrote in message
news
Would someone out there be able to share with me how to create forms that
are populated from other tables that are related by two many-to-many
relationships?
Thanks for any and all of your suggestions.

Not a good idea to post your email address in these forums, as the spambots
are constantly scanning for addresses.

My address is there in the sig, but we prefer for the discussion to take
place in these forums where everyone can benefit.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"tbride" wrote in message
...
Allen: I have one more question... do you have an email that I could
discuss my issue with you? I may be reashed at

----- Allen Browne wrote: -----

You need a 3rd table between the other two, to resolve the
many-to-many into
a pair of one-to many relations.

Then create a main form into one of the main tables, with a subform
into the
junction table.

For an example, see:
http://allenbrowne.com/casu-06.html


"tbride" wrote in message
news
Would someone out there be able to share with me how to create
forms that
are populated from other tables that are related by two many-to-many
relationships?
Thanks for any and all of your suggestions.