Filter List in Subform based on another field in the Subform

hi there,

I want to filter a list in a subform based on the value of another field in the same subform.
I want to know if it is possible and how to achieve this.

Let me explain in general what I want:

suppose you have a list (from a table) with all Premier League players - with a field containing the clubs they belong to
and you want to select one of the players in the subform (to attribute a value to this player)
and you have a list of clubs in the subform too
when you select one of the clubs - the too long list of players - should be filtered based on the value of the field club

How to do this?

cheers,

Wiebe