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?