Sport Teams Database with age restrictions

[Nitesh]

Hi Guys,

I have a table called Sport (ID, Description, Active)

Example data:

1   Soccer   1
2   Cricket   1

Then I have a Teams table(ID, Description, Active)

1    Under 14A   1
2    Under 15A   1
3    Under 15B   1

Since soccer and cricket can have an Under 14A team I have a table called Sport_Teams that links a team to a sport

ID, SportID, TeamID

1    1           1
2    2           1

Those are the basic tables. I need to add an age restriction to a team. I have a people table(Peopleid, Name, Surname, DateOfBirth)

When I select a team from a dropdown, I need to then only display the people who's age group falls under the age restriction for the selected team. What is the best way to do this. for example if I select Soccer, then the Under 14A team, I then need to only list people who are under the age of 14.

Please advise me. Thanks