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

Question

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 any luck adding a Summary field (distinct count using `Client Name` field in `Clients` table).

To summarize, I need to know how many clients are subscribing to products.

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

markshnier__you · Answer

Can you clarify your relationships?
Do you in fact have a many to many relationship where one client has many Client Products Assignments but also one Product has Many Client Product Assignments?

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

mattmakris · Answer

One Client record has many Product records------------------------------Matt Makris------------------------------

markshnier__you · Answer

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

Forum Discussion

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