GetNth in FM 7

[Genx]

ok, im going to assume that if you develop something in fm 8, you cant expect functions such as GetNthRecord to work in fm 7... so my question is, was there some sort of work around you could do in fm 7 to achieve the same type of result?.. (keep in mind i only need the first two related records)...

cheers, genx

[comment]

It's possible. Roughly speaking, you define a value list of all related ID's, then extract the Nth value using MiddleValues(), and base a new relationship on that. Getting the sort order can be a bit more tricky, but basically you sort the value list by your sort field.

[Genx]

exactly what i needed again, cheers comment

genx

[BobWeaver]

Another method is given in this thread:

http://www.fmforums.com/forum/showtopic.php?tid/92703