Creating forms that populate many to many relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

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

tbride said:
Would someone out there be able to share with me how to create forms that
Click to expand...
are populated from other tables that are related by two many-to-many
relationships?
 
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

tbride said:
Would someone out there be able to share with me how to create forms tha
Click to expand...
are populated from other tables that are related by two many-to-man
relationships
 
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.

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