Forum Discussion

RecruitmentSona's avatar
RecruitmentSona
Qrew Trainee
7 years ago

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 w...
Formulas and functions
Quickbase Automations
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Have you you tried a Summary report and Group by Meeting Person and then add a Group by Client.
RecruitmentSona's avatar
RecruitmentSona
Qrew Trainee
7 years ago
i have group by meeting date - monthly and then group by meeting person - equal values,
even if i add group by client - i cant eliminate the multiple meetings with the same meeting person with 1 client.
but i ll still try