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:

Department1

Department2

Department3

 

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?

 

Thanks...

Outcomes