### 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.

In your example, I don't see any let function and I don't see any relationship. and for some reason, you have double spaced your list.

If you are using a relationship to match to the records you want to see listed, you can use a much simpler calculation:

Substitute ( List ( RelatedTable::SeriesandDescription ) ; ¶ ;"¶¶" )

The substitute takes the single spaced list of values and doublespaces it.

But also consider that a portal to the relatetable can also list these series without any calculation needed at all.

For FMP 12 users, the ExecuteSQL function is also an option that can be used to list these values in a single field and no relationship need be defined for it in the relationships graph.