How to associate, Age Division, Team Name and Player
I need to find a way via relationships, or somehow to do the following:
I have a table "Age Division" (11U, 12U, 13U, etc..)
Another table called "Team Name" (Red, White, Blue, etc)
I need to join the "Age Division" and "Team Name" to get something like the following. 11U Red, 11U White, 12U Red, 12U White, etc..
By adding Age Division and Team Name, I will have the team (12 Red)...then I need a way to associate a player to that team.
I am not understanding what I need to do...any help would be appreciated