May 14, 200817 yr 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 ;)
May 14, 200817 yr 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.
Create an account or sign in to comment