Skip to Content
0
Dec 17, 2018 at 06:17 AM

Omitting records from one table depending on data from another table

61 Views Last edit Dec 15, 2018 at 11:59 PM 2 rev

I have a client's table and a charges table:

If a client has a felony charge then I don't want to include that client in my report at all.

Currently, I have the following code in my record selection:
not ({charges.chargesType} = "Felony")
so it will still include client 1 and client 3 just not the felony rows.
I don't want client 1 nor client 3 in my report at all since they have a felony record. How can I omit them from my report?

Attachments

clients.png (7.0 kB)
charges.png (8.2 kB)