Jump to content
  • entries
  • comments
  • views

FileMaker Pro | Script | Record Navigation

Skeleton Key


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



Recommended Comments

There are no comments to display.

  • Create New...

Important Information

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