Count of Category?
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