8 Replies Latest reply on May 23, 2017 12:18 PM by greengk2fi

    Go to Record in Found Set Based on Primary Key

    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.