So I would create a table called games and join with the user default table. I`ve created a table game with 4 columns players and these 4 players are users so the player type is a type user. so I would like to bring their photo by table game. how do I do it?
If you assigned everything correctly, while displaying a game, you would just get the player fields of this game.
If there is a page with page type game, you can display the players of the game such as Current Page's Game's Player1, Current Page's Game's Player2 etc. (assuming you named these columns as Player1, Player2, etc.)
If you display the list of games in a repeating group, then you will display the players using Current Cell's Game's Player1 and so on.
But of course, User is a special table, so you might need to play with privacy a little bit to display these players from the Game datatype: Protecting data with privacy rules | Bubble Docs
That’s the best I can do with this limited knowledge 
1 Like