If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Creating forms that populate many to many relationships
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. |
#3
|
|||
|
|||
Creating forms that populate 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
----- 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. |
Thread Tools | |
Display Modes | |
|
|