Jump to content
  • entries
    126
  • comments
    0
  • views
    53,009

FileMaker Pro | Script | Record Navigation

Sign in to follow this  
Skeleton Key

670 views

<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

Sign in to follow this  

×

Important Information

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