Forum Discussion
Is it possible to have 1:M:1 and 1:M:M forms
I'm hoping it's possible to create 1:M:1 and 1:M:M forms. Simple version is I have three tables, Students, HostFamilies, and Placements. While most students stay in the same placement over the course...
KevvieMetal The sample database here demonstrates the use of a main form/sub form design to handle M:M relationships.
Thanks. I'm pretty good with basic two-table relationships (1:1, 1:M, and M:M), but I'll definitely dig into that. What I'm really bumping up against is the more complicated relationships. It doesn't help that I don't usually get the chance to work on this until after 9pm -- I'm already exhausted when I start!
- I get that. I'm no good after 7:00pm.
- For many-to-many relationships one intermediate table must be used.
Example :
Table X ----- Intermediate table X-Y ---- Table Y
element A----A...1-----element 1
element A---A...2-----element 2
element B----B...2-----element 2
element B----B...1-----element 1
