I have 3 tables: Players, Teams and Clubs.
Each Club can have up to two Teams.
Each Player can sign up to one Club and one Team of that Club.
In Players table I linked Clubs table and would like to have a team field, but limiting the option to the teams of the selected club. I tried to use Lookup, but the result wasn’t the desired.