Combobox populated by another combobox choice

The PlayerList tab has 7 separate lists (QB,RB,WR,TE,PK,DF," ")
When you choose POSITION (i.e. QB), the PlayerName combobox is populated with all of the QBs (that part works)

When you choose the QB player name, I want the NFL team box populated with that player's team from the QBPlayerList
(or if you choose a WR, the WR NFL team will be populated from the WRPlayerList.

Attached sample.