need to identify and eliminate duplicate records from combination of 2 different fields in a report
I have two tables: 1. Meetings, 2. Clients, the relationship between the two tables is one to many.
So multiple meetings can be done with one client. and multiple people can setup the meetings with same client.
I am creating a report in the meetings table where i want all total unique list of meetings i.e. only one record of "meeting person + client".
I have achieved the list of all the meetings but the problem is i am getting multiple records.
for example:
what i want is
meeting person 1 + client 1
meeting person 2 + client 1
meeting person 3 + client 1
meeting person 1 + client 2
meeting person 2 + client 2
meeting person 4 + client 2
------------------
but what i have achieved is:
meeting person 1 + client 1 (meeting 1)
meeting person 1 + client 1 (meeting 2)
meeting person 1 + client 1 (meeting 3)
meeting person 2 + client 1 (meeting 1)
meeting person 2 + client 1 (meeting 2)
meeting person 3 + client 1 (meeting 1)
meeting person 1 + client 2 (meeting 1)
meeting person 2 + client 2 (meeting 1)
meeting person 4 + client 2 (meeting 1)
meeting person 4 + client 2 (meeting 2)
meeting person 4 + client 2 (meeting 3)
