how to filter in combo box

[sigridish]

hi all! i have two combo box in my program

one has the subteam for example if you click the 1st combo box, the items would be
A1
A2
A3
A4
A5
what i want to happen is that if i chose A1 only the members of team A1 would appear in my combo box2. and by that, you need an sql statement. but how do i code that? can someone help me?

[pod]

pretty difficult to figure what you need without knowing your database schema

with the assumption your tblplayer has the following fields:

• playerid
• playername
• teamname

then your sql could be
select * from tblplayer where teamname = 1stcombobox

but the above schema would not be following good database design,

a better schema would have three tables:

1. tableTeams:
   teamid[PK]
   teamname
2. tablePlayers:
   playerid[PK]
   playername
3. tableTeamPlayersAssignement:
   teamid[FK]
   playerid[FK]

where in the tableTeamPlayersAssignement the two foreign keys can appear more than once in different combinations ...but never twice in the same combination.


I strongly suggest you read on relational database concepts