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

    Repeating Field and GetNthRecord not working as expected

    datastride

      Context:
      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 ...