Go to a specific record in a found set

[michelenyc]

I am using a script to perform a found set of records; however, I want to be able to go to a specific record in the found set. For example, I'm on the current invoice record for ABC Inc (Invoice #2) and I'm interersted to see what other invoices exist for ABC Inc. I want to perform a search for all ABC Inc invoice records, but once the set of records is found, I want to view the original invoice #2 first. I feel like I'm close to a solution, but not quite there. Please help!! Much thanks in advance. Michele

[-Queue-]

Create a self-relationship from the company id to itself and a self-relationship from a global to the record id. Set the global with the current record's id. Then you can use the Go to Related Record [show, self_id] step to find only related company records, followed by Go to Related Record [self_global|||id] to take you to the record you were on previously.

[bruceR]

That will get to the record; but you'll lose the found set that way. You'll either need to use applescript or a looping standard script. For instance this works and you don't lose the found set:

copy cell "gRecID" to x

go to (first record whose cell "RecordID" = x)

[-Queue-]

Actually, it won't lose the found set for the desired company since 'Show' isn't checked. As long as the record to be displayed is in the current found set, this poses no problem. I use it all the time.