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?