Linked field selections based on previous linked field

[Abbie_Allen]

Hi. I have a table with two linked columns. In one column you select a the Client (from the Client table). In the next column you select the Project you are working on for that client (from the Project table). (In the Project able there is a linked field to the Client table). When I go to select the Project, every project in the project table comes up, instead of only those projects related to the Client in the previous field. Is it possible, when I select a particular client, only their projects show up as choices in the next field? Let me know if you need any further clarification. I’ve tried my best to summarise below.

Table 1 - Current Tasks
Task name
Linked field Client Name (select client)
Linked field Project Name (the select from projects only related to the client in the previous field)

Table 2 - Projects
Project Name
Linked field Client Name

Table 3 - Clients
Client Name

[JonathanBowen]

Hi @Abbie_Allen, great write-up by @W_Vann_Hall of how to achieve this here:

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…

JB

[Abbie_Allen]

Thank you! I’ll take a look.