Hello. I have a table with customers and a table for invoices joined on customer_id. How do I create list or relationship that will show only the customers for which open, unpaid invoices exist. I use a field called "total" in the invoice table and when total=0, the invoice is considered paid.
I thought I could do it through the Relationships graph but can't figure out how to do it. There doesn't seem to be a way to say "AND total>0"
When opening the layout, I just want to see the customers with open invoice not all 4,000+ customers in the customer table.