Joining text from related records

[KieranYeates]

Hi quick question, i searched but couldn't think of the correct words to use to search for my problem

i have a port related to a database, with a list of products in it. on a layout showing a quote form. so my 2 tables are Quote and Products. the portal has a few related products to the quote. i want to take all the product names and put them in 1 feild one under another.

"Product1

Product 2

Product 3 "

and so on.

all i can find is to add numbers together from related records using a calculation feild and the sum function. can i make a loop to get the data out or is there a function that can do this for me?

[Vaughan]

The List() function does this, but it's new to FMP 8.5.

Alternatively you create a related value list to concatenate the fields together using the ValueListItems() function, but this will return a list that is sorted alphabetically with duplicate entries removed. It's also a slow function to process. (I dunno whether the List function is better I haven't used it yet.)

[wintergreen]

I've been using the list function for quite a lot of things. Seems as fast as most other functions.