There are games played by four players, each of which is ranked. Users can see the Rank of the games they have participated in.
I created the following database, and was able to create the desired application by filtering myself in the Inline list and displaying my Rank at that time.
| UserID | GameID | Rank | | user1 | game1 | 1 | | user2 | game1 | 2 | | user3 | game1 | 3 | | user4 | game1 | 4 | | user1 | game2 | 2 | | user2 | game2 | 1 | | user3 | game2 | 3 | | user4 | game2 | 4 |
However, this database would accumulate too many records for each game. So I would like to create a database like the following to create the desired application.
| UserID 1 | UserID 2 | UserID 3 | UserID 4 | GameID | Rank 1 | Rank 2 | Rank 3 | Rank 4 | | user1 | user2 | user3 | user4 | game1 | 1 | 2 | 3 | 4 | | user1 | user2 | user3 | user4 | game2 | 2 | 1 | 3 | 4 |
With this design, is it possible to display the Rank of the games I have participated in in an Inline List? The problem is that I don’t know where the column that contains my ID is.
Any help would be much appreciated it!
- I Added examples.