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.
Any sage advice? Thanks.