Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
2 years ago

How to get a count of unique parent records in a relationship

I have a relationship between my `Clients` (parent) and `Products` (child) tables. In a Summary report in the `Products` table, how can I display a total number of `Clients` records? I'm not having an...
MattMakris's avatar
MattMakris
Qrew Cadet
One Client record has many Product records

------------------------------
Matt Makris
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago
Why not just make a report of Clients filtered by if they have Products (ie where the have child records).  Then the report will tell you how many clients there are.  It can be either a summary report or a table report.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------