Script/Calculation Problem

[Machi]

Hi there. As part of a database Ive developed i had to include a field that summarized the information from a portal. I did that using the "List" Function to create a calculation field that looks like this:

Substitute (List (tablename::fieldname);[enter symbol];",".

The calculation gets the information, and presents it as a comma separated list. It works perfectly fine in my computer, im using FMP9.

Ok, what i didnt know was that they wanted to use the database on FMP8, where it seems the "list" function does not exist... is there a workaround for this? maybe the list function had another name in older versions? help?

[comment]

The List() function was introduced in version 8.5. To do a similar thing in version 8 you can define a value list of related items only, and use ValueListItems() to list them. The difference is that (a) only unique values will be listed, and (: the list will be sorted alphabetically.

If you have the Advanced version (8 or 9), you can write a custom recursive function, using the GetNthRecord() function.