AnsweredAssumed Answered

Go to Record in Found Set Based on Primary Key

Question asked by greengk2fi on May 23, 2017
Latest reply on May 23, 2017 by greengk2fi

I have a scenario in which I want to have FM show a found set; but then make active/go to a particular record in that set based on it's primary key.


For example, I'd like to load all invoices for a particular client; but then go to a particular invoice based on a variable that holds the PK invoice ID.

It's very easy to get the found set, sort it, and then go to first or last record. However, since I only know the PK of the item I want to go to (I don't know it's position in the found set because it's not always first/last), I'm a little stumped about how to make that record active. I think I'm missing a conditional term. I use Go to Record with a calculation putting the PK = $Variable. While that's what I want, I can see FM not recognizing that as a cal for record number. How do I go about this? Here's the snippet from the script.


Screen Shot 2017-05-23 at 10.38.29 AM.png


Any sage advice? Thanks.