Returns the contents of a RELATED set by number.

[ouralien]

Hi

I would like to returns the contents of a RELATED field specified by number in a calculation.

Like the last() function, which returns the last value in the related set, if it's not a repeating field, I would like to get a specified value by a number.

Also like the GetRepetition(repeatingField;number), but with a related field instead of a repeating field.

I've been searching for ages

Thanx a lot in advance for any help or hints.

I'm using OS X and FMP7 Dev

[Fenton]

ValueListItems (Get(FileName), "value list name") will get you the values matching a relationship. The MiddleValues function will let you pull one out by number. It must be either an unstored calculation or script; or it could be auto-entered via calculation when the number is chosen.

(P.S. The Value functions, for some reason known only to FileMaker, return the value AND the paragraph return after it, so you have to use Substitute to remove it.)

[ouralien]

I'm going to try that solution. But it seems to solve my problem.

I haven't thought to use a value list.

Thank you a LOT.