I have a simple pair of tables to collect and process usability testing notes. In my main table, I have each note as a record, and there is a lookup field for tags that apply. The tags are in a linked second table. I.e., each note may have multiple tags, and each tag may have multiple notes.
I want to view each tag with a list of the corresponding notes below. I can see that here in the expanded record view. Like this:
But I can’t figure out how to do this in a grid view to get an overview, e.g., with groups. I get all the tags aggregated or the notes aggregated. Like this in the second group:
I suspect this is a simple issue but I can’t figure it out. Suggestions?.