I have a custom list with People, Courses, and Completion Dates. People take multiple courses, and sometimes they also take a course again to refresh. I would like to show the list with all people and all courses, but if a person has taken the same course
multiple times, I only want to show the last time the course was taken. In SQL this would be some sort of a DISTINCT query over the combination of PERSON and COURSE. Has anyone done something like this with SP lists (without code ;-) ).
A workaround would be to flag expired courses, once the person has taken the course again. This way you could filter for the not-expired records, but maybe there is a better way. Suggestions?
View Complete Post