Filter on most recent input
I have two related tables (files and action). The action-table contains information about the things I did in the various files. If there is a new action the former actions stays in the table so that I can always see what I did in the past. Each new action gets a timestamp. I would like to make a list that per file only shows te most recent actions. I made a latout with the field filename from the files table and a portal with fields from the action table. I want to filter the related fields so that only the most recent entry per file shows. After that I want to sort the related fields so that the action with the highest priority is on top of my list. I dont know what funtion I should use for filtering. Can anybody help me with that? Sorry for my poor English.