Discussions

 View Only

  • 1.  How to get a count of unique parent records in a relationship

    Posted 02-06-2023 12:36
    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
    ------------------------------


  • 2.  RE: How to get a count of unique parent records in a relationship

    Posted 02-06-2023 12:52
    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
    ------------------------------

    Original Message


  • 3.  RE: How to get a count of unique parent records in a relationship

    Posted 02-07-2023 11:07
    One Client record has many Product records

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

    Original Message


  • 4.  RE: How to get a count of unique parent records in a relationship

    Posted 02-07-2023 18:02
    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
    ------------------------------

    Original Message