Concatenate related records ?

[Steven Cappiello]

Hi there,

I have portal which shows related records (short notes-- one sentence). I'd like to concatenate all the related records into one note with each of the records separated by a carriage return.

Is the best way to do this to create a stored calc that has the note and a carriage return and then to use ValueListItems in a calc looking through the relationship??

thanks ;)

[Fitch]

Your approach will work, or you could use a recursive custom function. If you had FileMaker 8.5 you could just use the List function.

[Steven Cappiello]

thanks Fitch.