AnsweredAssumed Answered

Let Function Question

Question asked by ShirleyMB on Aug 30, 2012
Latest reply on Aug 30, 2012 by philmodjunk

Title

Let Function Question

Post

I have a related data base of only 10 records which include, record ID, series names A to J, series titles, and series descriptions. A calculation field shows the information in one field (SeriesandDescription). I created a field called “Series All” showing the information from those 10 records using the Let function. When I decided to change any aspect of a series (e.g. switching series G and H or changing the title of one series), the information does not appear in the related data base. (I renumber the record ID and sort by it.) Am I using the wrong function? Here is my calculation for the Series All field:

 

GetNthRecord (SeriesandDescription ; 1) & "¶¶" &

GetNthRecord (SeriesandDescription ; 2) & "¶¶" &

GetNthRecord (SeriesandDescription ; 3 ) & "¶¶" &

GetNthRecord (SeriesandDescription ; 4 )& "¶¶" &

GetNthRecord (SeriesandDescription ; 5 )& "¶¶" &

GetNthRecord (SeriesandDescription ; 6 )& "¶¶" &

GetNthRecord (SeriesandDescription ; 7 )& "¶¶" &

GetNthRecord (SeriesandDescription ; 8 )& "¶¶" &

GetNthRecord (SeriesandDescription ; 9 )& "¶¶" &

GetNthRecord (SeriesandDescription ; 10 )

 

Thanks in advance for anyone’s help.

Outcomes