5 Replies Latest reply on Jan 22, 2017 9:34 AM by datastride

    Repeating Field and GetNthRecord not working as expected


      An unstored calculated field with 11 repetitions.


      Planned usage:

      To display data on a printed report where "Slide Up" is needed. ("Slide Up" won't shrink the height of rows within the portal.)


      If defined as:   


           Get( CalculationRepetitionNumber )


      The 1st repetition is set to "1", the 2nd to "2", the 3rd to "3" ... as expected.


      But when defined as:


          GetNthRecord( Related_Table::Field_in_Related_Table , Get( CalculationRepetitiionNumber ) )


      The 1st repetition contains the data from the 1st related record in the related table, but all other repetitions are blank (whether or not there are more than 1 related record).


      Anyone have any idea what I'm doing wrong?


      Thanks for any thoughts ...