I have two linked tables on a field called “customer”. This works great for issue tracking, because I can add a customer to a specific issue and know who needs to be followed up about it, or quickly get their current status.
I’d like to group by the Customer field. However when I set this grouping up, it treats the following as separate groupings:
- B, A
- B, A, C
and so on. Is there a way to view the grouped view so all of Customer A’s associated issues will show up under Customer A, rather than 1 under A, 1 under B, A and 1 under B, A, C?