found something on other website as below, please advise if this will work as there are some complications
that how to show the scores as the format of Tenis score is different
Something like
tblPlayers
playerID
playerLastName
other player information
TblTournment
tournamentID
tournamentName
tournamentDate
other tournament info
TblMatch
matchID
matchType (single, double)
tournamentID (relates to the tournament)
other match specific information
TblMatch_PlayerScores
matchID (relates back to tblMatch)
playerID (each player in a match gets a record)
score (score)
winlose (because you may just save scores as text)
Not sure how you plan to enter scores because if you tracking sets then you need another table. But if you just need the string. then:
12 3 "6,3,6,7,6" win
12 7 "4,6,7,6,4" lose
So in tournament 12, player 3 played player 7. Final score was 6-4, 3-6, 6-7, 7-6, 6-4.
If you are tracking the sets then need a set table
tblSets
matchID
playerID
gamesWon
winLoseset
But yes if you want to be able to get specific player scores then you need a record for each. A much more complicted way would be to only save the scores and relate them to the match. Then you would have to write code to parse them out.