Calculation to list current found set record IDs

[Hijack]

Anyone aware of a way of getting a calculation field to always reflect a summary of the record IDs of the current found count? Meaning, if the Record ID fields of my current found set are 4, 7 and 9 (three records), can I create a calculation that shows:

4

7

9

?? My overall goal is to create a relationship to show a portal of whatever the found count is without having to script in my own Find process that always sets a global to the record IDs of the current found set.

The new List function doesn't seem to be of much help here.

Thanks

Edited November 27, 2006 by Guest

[comment]

Try a custom function (or a repeating calculation field) using GetNthRecord().

[Hijack]

Can't really see how that might be used. Any ideas how to impliment such an approach?

Thanks

[comment]

Like this?

FoundSetPortalR.fp7.zip

[Hijack]

I bow to the superior intellect. I didn't have a full grasp of how repeating fields could be used in this way. This will really help me create more streamline and responsive databases.

Thank you very much for taking the extra time to build an example database. I really appreciate it.

David Wolfe

Indianapolis, Indiana

Edited November 29, 2006 by Guest
I can't spell worth didly.

[Inky Phil]

Wow,

I guess I really ought to change my skill level back to novice

Thanks

Phil

[Julian K]

In case anyone else needs to do this, and has many records (more than 500), this solution could work: http://fmforums.com/forum/showtopic.php?tid/211266/post/341907/hl//fromsearch/1/#341907