10 Replies Latest reply on Sep 7, 2013 6:37 PM by ChrisJohnston

    Count of Category?

    ChrisJohnston

      Title

      Count of Category?

      Post

           I have two tables that have a one to many relationship, I would like to get a count (number returned) from the ONE table so I can see how many are in that category for each category. Would this best be done with a Summary field and table occurrence or is there better method to do so. My database is Subject (one) and Information (many) how in a layout related to Subjects can I have a field that reports how many (number) of a particular piece Information I have for that subject? Kind of like in SQL "SELECT * FROM information WHERE subject name = something" and then return the result as a number. Thanks