Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 4589 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

Posted

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).

Posted

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?

Posted

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.

Posted

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.

This topic is 4589 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.