<p><a href="/blog/Quickly-Navigating-to-a-Specific-Record-Within-a-Found-Set"><br /><h1>Quickly Navigating to a Specific Record Within a Found Set</h1>

<p></p></a></p>

<p><a href="/images/Blog/BullsEye.png" align="right"><img width="100" height="95" src="/images/Blog/BullsEye.png" /></a></p>

<p>Recently I needed to have a FileMaker Pro 12 script navigate to a particular record within the found set after performing some action. There are several situations where this could occur, such as a scripted Extend Found Set or Constrain Found Set or perhaps when looping through the found set and either omitting, deleting, or duplicating certain records.</p>

<p>My first thought was to simply capture the ID of the current record at the beginning of the script and then loop through the found set at the end of the script and exit the loop on the correct record. What I discovered was that this was unacceptably slow with larger record sets. So here's a better method.</p>

<p><a href="http://www.skeletonkey.com/blog/Quickly-Navigating-to-a-Specific-Record-Within-a-Found-Set" target="_blank">read more</a></p>

Source