Duplicate Application

Duplicate Application

Hey guys,

I have a travel company that helps students to get their visas to their universities, I have a problem with duplicate students' reports, for example, I have student X who wants to go to a university, for example, he applied to AB university and CD university, he got accepted in AB university first since he gets accepted I don't want the CD university to appear in a research report, any help how to filter the students who have applied for different universities to filter only the accepted application? I don't want the non-accepted one.