I'm working on an application that has many many-to-many relationships.
In this applications there is a search feature.
With this search you are able to search for a person.
A person can belong to one or many companies, and may(but not necessarily) have a different set of contact information for each company.
Because our users need to be able to edit contact information based on the person-company relationship, I am currently returning each relationship to the search results.
John Doe - Company A John Doe - Company B John Doe - Company C
This becomes an issues for multiple reasons like resources and confusion, as sometimes very subtle changes in contact information make identifying the desired result very time-consuming.
Does anyone have an example or solutions for searches dealing with very similar results or relationships.