How to only select Table Linked records with a condition?


#1

I would like to have a Jobs Table, where I can log jobs I have done for my clients.

I have a list of clients, some of which are not active.

I want to be able to select a client on the Jobs Table, but only display the “Active” clients.
image

How can I do this? I’ve played around with rollups, functions, arrays, and I can’t get anything to work. Ideas?


split this topic #2

4 posts were merged into an existing topic: Filter data for linked fields


closed #3