Forum Discussion

ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
Solved

Matrix using one field for columns and rows

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 f...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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