OK...guys... I'm about to have a cow here. It sounds real simple but I just can't seem to get it.
Here is the deal: I have a normalized database made up of four tables (Primary Key in bold)
Player (PlayerID, PlayerName)
NHLTeam (NHLTeamID, PoolTeamName)
PoolTeam (PoolTeamID, PoolTeamName)
PlayerStats (PlayerID, NHLTeamID, PoolTeamID, Points)
My software already displays the list of NHL Teams (or Pool Teams for that matter) in a MSFlexGrid - that's the easy part. When I select a team from that grid, I want the software to populate another MSFlexGrid that will contain a list of players that play for that particular team and sort them by the amount of points they have accumulated.
My question is: can this be done, and if so how? I would appreciate any help as I'm running out of hairs to pull.