3 Replies Latest reply on Sep 6, 2013 12:24 AM by Imre...

    show most recent

    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