Create a view where items show up in multiple groups


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.
Who is Participating?
David LeeConnect With a Mentor Commented:
Greetings, timnorvel.

The problem is that Account is a text field whereas Categories is a keyword field.  The only way I can see to accomplish what you want is to create a custom form and add your own field, making sure it's a keyword field, for storing the accounts.

timnorvelAuthor Commented:
Thanks BlueDevilFan.  That's the piece I needed - the fact that it's a keywork field.  I am actually in the process of making a custom form for our contacts, so I should be able to do that.

Thanks again,
David LeeCommented:
You're welcome, Tim.  Glad I was able to help out.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.