Help me out guys, I'm probably missing something obvious?
Here's the problem: a user can only access a certain set of records, other records marked with "no access". Said user often performs searches and likes to do a "show all" command to see the full picture from time to time. What I cannot do is subvert the show all command to make FM display the current record while filtering out the rest. As we all know it's easy to filter out "no access" records by running a simple find, however that has a side effect of returning you to the very first record while I want to stay where I was! I've tried everything: constrain, extends, even loops - they don't work as I need. "Go to Record" doesn't work because the record number it uses always changes. Short of creating a relationship is there a way around with a script? Ideally I'd love to see something like "go to unique record id" step but can't find anything like that in FileMaker.