Creating forms that populate many to many relationships

[tbride]

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 Browne]

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.

Reply to group, rather than allenbrowne at mvps dot org.

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?

 

[tbride]

Allen: I have one more question... do you have an email that I could discuss my issue with you? I may be reashed at (e-mail address removed)

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

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

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

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

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

Would someone out there be able to share with me how to create forms tha

are populated from other tables that are related by two many-to-man
relationships

 

[Allen Browne]

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.

Reply to group, rather than allenbrowne at mvps dot org.

Allen: I have one more question... do you have an email that I could

discuss my issue with you? I may be reashed at (e-mail address removed)