choose specific linked records

374 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi I hope you are doing well,

I am new at using Airtable and I have created 4 tables in Airtable : clients, sites, projects, partners and agencies, the relationships are that to each client we assign sites and to each site we assign projects and to each project we assign agencies that are related to partners based on the region so in the table project for one project we may have more than one agency but I want to creat a column in project where we can only keep the agencies that are checked in the table of agencies.

Thank you for your help

1 Reply 1

I think you can accomplish this via the "Limit selection to view" option:

Screenshot 2023-02-03 at 6.47.46 PM.png

In your "Partners and Agencies" table, create a view with filters that only displays the agencies that are checked, and then in your "Projects" table, select that view in the linked field's options