Matrix using one field for columns and rows

[ezequiel]

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 · Accepted solution]

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