Limit selection based on a linked table

[Financeiro_ABRQ]

Hi!
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?

[pcbowers]

@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:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…