timnorvel
asked on
Create a view where items show up in multiple groups
Hello,
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)?
Thanks,
Tim
p.s. I'm using Outlook 2003 and Exchange 2003, if it makes a difference.
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)?
Thanks,
Tim
p.s. I'm using Outlook 2003 and Exchange 2003, if it makes a difference.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome, Tim. Glad I was able to help out.
ASKER
Thanks again,
Tim