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

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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's avatar
      MattMakris
      Qrew Cadet
      2 years ago
      One Client record has many Product records

      ------------------------------
      Matt Makris
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        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
        ------------------------------