I'd like to create a view on a public folder that groups contacts by the Account field. Easy enough. But some contacts have multiple account reps. This means that a contact with "John Doe" as the account rep shows up under the John Doe group, but a contact with "John Doe, Jane Doe" as the account reps doesn't show up in the John Doe group, just the John Doe, Jane Doe group. I understand why - they appear as unique entries in the account field - but I see the functionality I'm looking for in the built in By Category view, which is also just a field with comma seperated values.
When you click the By Category view each group has only one category listed and if a contact has multiple categories associated, it shows up in each respective group. Is there a way to do this with other fields (i.e. the Account field)?
p.s. I'm using Outlook 2003 and Exchange 2003, if it makes a difference.