Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Limit selection based on a linked table

Topic Labels: Base design
368 1
Showing results for 
Search instead for 
Did you mean: 

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.
Any help?

1 Reply 1

@Financeiro_ABRQ This question has already been somewhat answered by @W_Vann_Hall in his post. While complex, it will allow you to select a Club and then limit your selection to your respective Teams given some tweaking: