List linked records not linked

[Widad]

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

[TheTimeSavingCo]

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

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