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

    Show Last Related Record

    rkutcher

      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
          philmodjunk

          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
            rkutcher

            Thank-you.  The portal works beautifully.

             

             

            Regards,

             

            Richard Kutcher

            Kutcher Engineering & Inspections Inc.

            250-885-6844