Using calculations, are there any way to grab 1 value from diferents related records?

Maybe is a stupid question… but I'm blocked.

To give you an exemple… It's like a Client - Contacts relationship. You have 1 client with 22 contacts. I would like to pick up just the surnames of this related contacts (separated by commas), but in 1 calculation field only (no portals, no print), result= Text.

Any ideas, please, please, please

The 'ValueListItems' function might be able to do this for you.

Define a value list returning related data from your surnames field.

Then define a calcuation field using the 'ValueListItems' function (have a look at FileMaker help fo syntax). I think it returns a list separated by carriage returns, you could use the substitute function to change the returns to commas if required.

I haven't tested this, but it might get you on your way to a solution.

The SumText function in the Troi Text Plugin will do this.

Thanks, Surwoop…

but the field that I want to grab is a unstored calc (It's like… in the Clients-Contacts exemple, to get all surnames of 1 clients but only those from the same city, for exemple!!)… so It can't be indexed.

That's why I can not use "Valuelistitems" functions.

Nice try anyway. thanks.

It should be another way to to that, shouldn't it?

(No portals, no scripting… just calculations and relationships)

No scripts, unstored; the only thing I can think of is FileMaker 8 and a Custom Function using GetNthRecord(field, #).

But I think you're wrong about the "unstored". The value list can be "filtered by" a relationship, using Client AND City (or a global City choice), related values only, from Client. The fields themselves, in their table, are still indexed. ValueListItems() will work.