AnsweredAssumed Answered

Show Only Customers with Open Invoices?

Question asked by MikeTrivisonno on Jun 30, 2018
Latest reply on Jul 2, 2018 by MikeTrivisonno

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.

Attachments

Outcomes