Calculating fields

Calculating fields

Hi

At the moment I am creating a database for a football club.
The database is suppose to hold the information of all players.

All players are put into age groups as follows

Boys:
Age: Group
5 and less u5 small feets
5+6 u7 poders
6+7 u8 sand players
8+9 u10 mini boys
10+11 u12 little boys
12+13 u14 boys
14+15 u16 junior boys
16+17 u17 yngling u17 boys

Girls:
Age: Group
5 and less u5 small feets
5+6 u7 poders
6+7 u8 sand players
8+9 u10 mini girls
10+11 u12 little girls
12+13 u14 girls
14+15 u16 junior girls
16+17 u17 yngling u17 girls


The age determind which group the player is put into. What I think of doing is to make a calculating table where age is calculated via :
year of bearth - existing year = actual age ex. 1996-2007=11 => equals little girls or girl!

In the above ex. the player with the age 11 would automatical be put into the group u12.

Furthermore every player are via radio button or checkbox marked as girl or boy.

Beside the above rules it should be possible to overrule it by putting ex. a player aged 8
into group u12

Do you have any suggestion, how to solve above? Or do you have a database where the same issue is shown?

BR Dennis