AnsweredAssumed Answered

Go to First Record Containing Particular Value

Question asked by rmittelman on Sep 17, 2013
Latest reply on Sep 20, 2013 by fmp

This is probably a very simple task. I want to be able to jump to a given section of my table records. Not filter, just jump there.


The table has records like:

Department1 Item1 DeptFind

Department1 Item2 DeptFind

Department2 Item1 DeptFind

Department2 Item2 DeptFind

Department2 Item2 DeptFind

Department2 Item3 DeptFind

Department2 Item4 DeptFind

Department2 Item5 DeptFind

Department3 Item1 DeptFind

Department3 Item2 DeptFind


DeptFind is a global field. My form has a popup menu based on DeptFind. Also, DeptFind has a Values From setting such that it gives me a distinct list of all departments when clicked on:





Selecting a value from that popup sets the global DeptFind field. So far, so good. Now, all I need to do is figure out the script to jump to the first record for that department in the current found set.

I know this should be easy, but I'm quite new at FMPro. I was thinking of using Go To Record as a script step, but it requires a record number. I can't figure out how to ascertain the record number of the first record for that department in the current found set.


Can anybody suggest how to do this, or an alternate method, given that I've got the desired department name in the global field?