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
yeah, my reports already had the summary. but as i said its not giving the desired results. when i group by with client name i get results as 4 (since there were 4 meetings)