Help

How to only select Table Linked records with a condition?

2032 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jamie_Walker
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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

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?

0 Replies 0