Solved: Matrix using one field for columns and rows

ezequiel · ‎06-19-2018

Hi,

I'm building a fixture-type report for a local tennis tournament. Teams will play again each other (10 teams) and I want to visualize the results in a matrix in which I should have the same field in rows and columns to have then the results on each game. I'm confuse on how to build this matrix with the same field. Can you provide any guidance?

Thanks,

Ezequiel

Anonymous · ‎06-19-2018

Try splitting that out into a "Home Team"/"Away Team" relationship. Basically, it's a "Many-to-Many" relationship on one field, but that associative entity will have a reference to both teams, plus additional information about the event occuring between those teams. You might need to denormalize into a single table for this using that logic.

https://en.wikipedia.org/wiki/Associative_entity

View solution in original post

Anonymous · ‎06-19-2018

Try splitting that out into a "Home Team"/"Away Team" relationship. Basically, it's a "Many-to-Many" relationship on one field, but that associative entity will have a reference to both teams, plus additional information about the event occuring between those teams. You might need to denormalize into a single table for this using that logic.

https://en.wikipedia.org/wiki/Associative_entity