Do you think there is a way to do this in reverse, IE I need to know when each player appears player 1 2 3 game player1id player2id player3id-player10id 1 1 5 7 so whereever player 1 appears, I ge tthe game # player game1-gameX 1 1 3 4 10 (so he appears in games 1,3, 4, and 10) does that make sense? I already have a data set checking which players are in each game, I want to check now what games each player is in. Since there are 1,000+ games, and 10 players in each game, will the array type function still work, with the format as Keith suggested in the original problem?
... View more