AnsweredAssumed Answered

show most recent

Question asked by Imre... on Sep 5, 2013
Latest reply on Sep 6, 2013 by Imre...

Title

show most recent

Post

     I have two tables, one shows PID (client_id) and activitiy_date, the other holds only PID's.

     I'd like to show on the layout of the latter (only PID's) the MOST RECENT activity from the first table.

      

     I figure it has to be done via a portal and either a filter or a sort.

      

     It won't work for me, or I cannot get it done. 

     Please help?

      

     Table one: "Deliveries" 

     PID: 1 , date 01-01-2011

     PID 1,  date 01-01-2013

     PID 2,  date 01-01-2013

      

     Table two: "PID"

     PID: 1

     PID:2

      

     In the layout "PID" I'd like to see the most recent date of layout "Delivries"

      

     How do I do this?

Schermafbeelding_2013-09-05_om_22.55.55.png

Outcomes