How to only select Table Linked records with a condition?

[Jamie_Walker]

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.

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