Dropdown lists - how to filter if it is not a lookup

Dropdown lists - how to filter if it is not a lookup

I have two dropdown fields: Location and Department.

I would like the Department dropdown list to display options based on whatever is chosen as the Location. Is this possible?

As always, thank you in advance!