I have an ACTIVITY table and a COMMENTS table. The COMMENTS table references a Specific ACTIVITY ID in the ACTIVITY table and I’ve set this up properly in the columns.
However, I’m looking for the expression to count the number of comments for a particular activity. Some activities may have 2 comments, others could have none but what would be the general expression? Also, I would like to display this COUNT in the ACTIVITY table, not the COMMENTS table as I would like to include a text field to say something like “This activity as 8 comments” which would be a concatenation.