2 Replies Latest reply on May 11, 2017 5:45 AM by rkutcher

    Show Last Related Record


      I have a layout with a field from a related record (a child record of a parent ---<child relationship)  .  I would like that related field to show the last related (child) record rather than the first.


      I might have seen something in the past about using   List    but can't seem to find that discussion now.


      Can anyone suggest a solution.   


      In case it matters, the field I want displayed is a container field with a PDF

        • 1. Re: Show Last Related Record

          There is the last function. It will return the value of a single field from the last related record.


          There is the option to use a one row sorted portal with a sort order that puts the last related record first. This can be done by sorting an auto-entered serial number or timestamp field in descending order.


          ExecuteSQL could also be used to return multiple values from the last related record in a single field.

          • 2. Re: Show Last Related Record

            Thank-you.  The portal works beautifully.





            Richard Kutcher

            Kutcher Engineering & Inspections Inc.