I have a table called Contacts where I list the people’s names, company, title, phone, email, etc.
I also have a table called Meeting History where I list the people, venue, date, and notes associated with my meetings.
In that same table, I have a field called Company, which I look up based on the people there. Pretty much all the meetings are with only one company, and usually there is only one person in the meeting, but, when if I record meetings with multiple people from the same company, can is there a way I can just show the single Company once in that field?
I meet with John and Judy from company ABC.
I add their names to the Contacts table and ABC as their company.
In the Meetings table, I put both their names under People; however, the Company field looks up both of their names and returns “ABC, ABC” as the Company.
Can it just show ABC once? Is there a way to get it to list just the unique companies in the meeting?