I have a team site with a contact list. Each contact is related to a
deal, so I have created a "Related Deal" field to capture this info,
and then want to display contacts grouped by Related Deal.
Problem is some contact are associated by more than one deal. If I
make the field multi-line, or multi-choice, I can no longer group by.

Anyone suggest a solution - other than putting the contact in twice?