Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
3 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...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 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 Assistant Captain
3 years ago
One Client record has many Product records

------------------------------
Matt Makris
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 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
    ------------------------------