1 Reply Latest reply on May 5, 2013 7:10 AM by philmodjunk

    Last record

    john9210

      Title

      Last record

      Post

           FM 12. Is there a way I can display in a parent record  the data from the last related record. All related records have a unique auto entered foreign key.

        • 1. Re: Last record
          philmodjunk
                 
          1.           There is a Last function that can be used to return a value from the last related record in a calculation.
          2.      
          3.           A portal can be used to display the record. You can set it to display just one row and if the table of related records has an auto-entered serial number for a Primary key, you can specify a sort order that sorts on this key in descending order to get the last related record.
          4.      
          5.           The same sort order can also be defined as part of the relationship and then a portal is not needed, you can just add fields from the related table to your parent layout and they will display the most recently created related record.