Filter Portal Records by last date dependant on another field entry
What I am trying to create is a portal onto a table of responses to meeting invitations. I want the portal to show only the most recent response recorded for each attendee.
eg. Bill Bloggs may respond on the 1/11/12 that he is attending the meeting and needs accommodation, but respond again on the 5/11/12 that he is still attending but no longer needs accommodation. Meanwhile, John Doe responds on the 6/11/12 that he is attending and needs accommodation.
I want to record each response in a table so that we have the history of what attendees have responded, however the portal just needs to show the most recent response from each person.
I hope this makes sense! Is there a way of filtering this in a portal?