Forum Discussion

Qrew Assistant Captain

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

Qrew Assistant Captain

One Client record has many Product records

------------------------------
Matt Makris
------------------------------

MarkShnier__You

Qrew Legend

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
------------------------------