Is there a way to get the response in one field to trigger a different set of options for the next field?

I'm trying to create a database that records stats for sports teams across different leagues.

So ideally what I want is if someone selects league 1 for the league field they then get a choice of the teams in that league to choose for home and away teams. Whereas if they select league 2 they get the choice of those teams.

Any help would be greatly appreciated.