Determining Portal Row without drawing a portal

[WilliamCB]

Is there a way to determine the rank position of related records with a calculation field?

In other words, I have a parent table and some child records. In the child records, I want to be able to have a field that stores the position of the record as it would appear in a given portal, defined by a specific relationship - which may or may not have a sort order defined.

This is so that I can use this data within results returned by the List function, which concatenates records from the child table. And so that I can report the rank of the child records in league tables.

Many thanks in advance,

W.

[comment]

It's possible, but it would require another calculation field in the parent table = List ( Child::ChildID ), which would be used in the child table to lookup each child's position in the list.

Alternatively, you could use a custom function such as http://www.briandunning.com/cf/941 to number the list.

Or you could simply produce the report from the child table.

Note that none of these methods produce the correct result in case of a tie - see:

http://fmforums.com/forum/showtopic.php?tid/201199/

http://fmforums.com/forum/showpost.php?post/241386/

[WilliamCB]

Perfect answer. Thanks v much.