Just found out the hard way, that when using the list function on a related field (in this case, a calculated field in the related table), if the calculated field is null, it is not included in the list of values
You get the same behaviour when using List() on fields from the current record. Change your calculation to include a dummy value, or use ExecuteSQL().
I expected there to just be a carriage return place holder in it's place in the list, but that is not the case.
This is a problem with your expectations, because the help system states very clearly:
I will upgrade it to 12.0v4 tonight, but I'm not hopeful that it will cure the problem.
Nothing to be cured.
I see that now, it just wasn't what I anticipated, and I have already changed the calculation to return a value when it is null.
Thank you for your reply
I guess the help topic <http://www.filemaker.com/help/13/fmp/en/html/func_ref1.31.4.html#1036551> was not "helpful" when it said "non-blank values" for List()?
If you need "blank" values, I suggest a loop script to place them:
go to record (first)
set var ( $myList = $myList & myfield )
exit loop if get(foundcount)=get(recordnumber)
go to record (next)
set var ( $myList = $myList & "¶" ) // append return except last "value", move this step above exit loop if needed
... do something with the variable $myList
Thanks for the reply, but changing the calculation field to be be equal to a space when it is null, was a simple fix.