Need to elaborate more on exactly what you are doing, what you are trying to do, and possibly offer a snippet of code you are tryin gto figure out.
thanks for the reply.
I'm building a simple voting system for a competition. I want to be able to visually eliminate entries, according to their position in the voting table. So votes may read 30, 23, 17, 16, 14, ... etc. I want to be able to enter a number in a global field, say 5, and have the top 5 entries flagged.
Normally I would do this with a Portal, but there is a specific layout required, which has meant 5 portals on a page (like a photo contact sheet).
Get ( recordnumber ) returns the record's current position in the found set's sort order.
In a calculaiton field, it will dynamically update in response to changes in the found set if you set the calculation field up to be unstored.