multiple M2M on one form - Many-to-Many in Microsoft Access


	Back to Many-to-Many Comments List

Upload Images Link Email

multiple M2M on one form

Susan Williams

2 years ago

I have 2 tables, IndividualT and ThemesT.  One individual has 5 unique themes. Some themes are "owned" by multiple individuals. I've set up a JuntionTable (IndividualXThemeT) and can replicate the forms shown in the Many-to-Many video. It's awesome.

Each Theme has a number of characteristics (description, value, frequency,....) These are all stored in the Theme table.

I need to create a Report for each Individual that displays EACH of their 5 themes AND the characteristics of each theme. (image below)

It seems like I would need 5 relationships, but that also seems clunky.  If I do need 5, how would I set that up, since each one is related the same (ThemeID).

Happy to add other images or files--thanks!  I learn a ton from this content and group!!

Susan

PS--sorry if this should be on a different topic

	Susan Williams OP 2 years ago

Kevin Yip

2 years ago

If your picture is what you want your report to look like, it may be difficult, even with crosstab query.  You may consider a simpler layout, such as below, which doesn't require any extra work.  A simple query such as "SELECT ThemeID, Description, Value, ... WHERE IndividualID = n" can do it:

ThemeID   Description   Value   Frequency
1         Data          Data    Data
2         Data          Data    Data
3         Data          Data    Data
4         Data          Data    Data
5         Data          Data    Data

	Susan Williams OP 2 years ago
Thanks, Kevin. Never dawned on me to go the other direction! Is it possible to turn a label 90 degrees, so it reads up instead of across? I don't see anything under Format or Arrange, but I'm pretty new to the program...maybe there's a trick :-)

	Kevin Yip 2 years ago
The "Vertical" property on the property sheet lets you rotate 90 degrees clockwise, but not 90 degrees counterclockwise, which is what I and most people would prefer. This is not like in Excel where you can rotate text any way you want in "Format Cells."

	Susan Williams OP 2 years ago
thanks. Yeah, clockwise seems counterintuitive. But better than nothing I guess. Thanks again for your help.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Many-to-Many.