How do I link filters together

See more:

MySQL

WordPress

I have the 1st 3 columns set up as Drop Down filters, Wk, Tm and Bowler.
What i would like to correct is to shorten the "Bowler" filter to the Bowler names connected to that team if the "Tm" filter is selected.

Example: If Tm #1 is selected, then only Greg and Linda should show on the Bowler filter.

I am using Mysql pre 2012

Table Data:
Wk	Tm	Bowler	Total
1	1	GREG PEARSON	418
1	1	LINDA BIAMONTE	451
1	2	JACI GAETZ	590
1	2	SYL WALLACH	417
1	2	JEANNE GIRARD	731
1	2	SCOTT FULLER	531
1	3	DIANE WEBB	378
1	3	LYNNE SIEBEN	580
1	3	CLAUDIA VANDERMER	431
1	3	TED TAYLOR	491
2	1	GREG PEARSON	445
2	1	LAURIE CAMPBELL	390
2	1	LINDA BIAMONTE	451
2	2	JACI GAETZ	642
2	2	SYL WALLACH	530
2	2	JEANNE GIRARD	598
2	2	SCOTT FULLER	527
2	3	DIANE WEBB	359
2	3	LYNNE SIEBEN	439
2	3	CLAUDIA VANDERMER	400
2	3	TED TAYLOR	394

What I have tried:

(SELECT 'Wk','Tm', 'Bowler','Total')
UNION (select Week
,TeamNum as "Tm Num"
,Bowler 
,(Gm1 + Gm2 + Gm3) AS "Total"
FROM `b_Scores` 
WHERE `TeamNum` < 4 
AND Week < 4
ORDER BY Week AND TeamNum)