For quite a while, I've used an unstored calculation field to retrieve/display fields from a specific record within a found set. For example:

Display::Name [unstored] = GetNthRecord ( Table::Name ; Record# )

Now I have a situation where I know the actual RecordID, but I'm drawing a blank on how to use it in a calculation. Is there a way to implement the above calculation using a RecordID? I'd like to avoid adding yet another Table Occurrence for such a small feature.

Thanks in advance for any help.

If you have the recordID stored in a field then you could write a recursive custom function to do this, would have some record number limitations depending on how you write it (max of 10,000 or 50,000 records in the table).

Thanks for your response.

Actually, I have from 2 to 20 Record IDs in a single text fields (a CR-delimited list) — which may complicate things. But I can fan them out into a working record, if need be.

Could you point me to an example of what you're suggesting?

check www.briandunning.com, in the CF section for anything like GetNethRecordSet, that'll give you a head start on recursion. There's a CF section here too that you can check out.

Your question is not clear. You speak of a specific record in a found set. How exactly do you know the RecordID value of that record? You also speak of a list of values - are these the values of the found set, in the order of the found set? If yes, you can determine the position of the known value in the list very easily.