Found set opens with 'wrong' record...

[moonunit]

In my first layout I have 6 records...

Records 1-4 have the same conditional value

I then do a find on this conditional value and (not surprisingly) get the first 4 records which appear in a related layout.

However, if I'm in record 2 when I initiate the search, I get the same four records but my found set starts at record 1.

Go to Layout [ Found layout ]

Perform Find [ Conditional value ] [ Restore ]

Go to Related Record [ From table: "Original"; Using layout: "Found Layout"]

What I'd love to achieve is performing the find, switching the layout and ending up at the record where the find was first triggered.

I've tried doing no end of variations without any success. Can anybody tell me whether or not this is achievable?

Tim

[mr_vodka]

When you perform a find it is not necessarily based off the record you perform the find at. So when FM performs a find, it returns the found set based off the find criteria.

However, if you did want to go to the record you started with, before you perform the find, capture the your recordID number into a global field. After the found set is returned, go the the record you captured into the global field.

[moonunit]

Thanks John...

I've got the ID and pasted it into a global but I can't seem to construct the "go to record" instruction properly.

Can you offer one more tidbit of a clue?

Tim

[mr_vodka]

Make a new relationship between the table of where the global is stored to your RecordId field. Then after your find is performed, go to a layout of the table where the global field is located and then Go to related record. It will leave you on the record you were on.

[moonunit]

I actually had a missing line in my test script...

Once I'd inserted an Exit if statement, it worked fine.

Thank you again.

Tim