Linked to another record field with filtering


#1

In this scenario, there are 2 tables. A Clients table and a Marketing Spend list.

Each Client has a Status (a single select that can be Lead, Account, Not Interested).

The Marketing Spend list have a “Linked to another record” field where we would only want the “Account” clients to be available to be choseen as an option.

How would we do this?