Skip to main content
Question

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

  • February 6, 2023
  • 0 replies
  • 49 views
MattMakris
Forum|alt.badge.img+7
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • February 6, 2023
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement