Use the Substitute() function to replace the carriage returns with commas.
The substitute command definitely helped, but I am running into another problem with the list command and related records.
If I have list(relatedtable::field1) and there are two related records (Joe, Smith; Bill,Thomas), it works fine:
But if I have list(relatedtable::field1;relatedtable::field2), I get:
but no info on Bill.
The related records are through a 'join table', but it seems weird that it would work for one field, but not two). Am I missing something on the syntax?
Like all aggregate functions, List() has several forms of syntax depending on the context. I don't want to get too confusing (you can look up the function in the help), so to make it short: you can only list one related field.
You could either define a calculation field in the related table to concatenate first and last names, or write yourself a custom function (if you have FMP Advanced).