Define a self join relationship between your layout's table and a new table occurrence with the same data source table. Set up a global field that your user uses to enter a door number as the match field to the door number field in your relationship. Use Go to Related Records, but without the "Show Only Related Records" option specified and if your door record is part of the current found set, it will be come the new current record but leave your found set unchanged.
Another option would be to open a new window or change to a new layout to show the selected record. You would close the window or return from the other layout return to your found set.
To keep the found set on a given layout unchanged do one of these:
- Perform a find or a Go to Related Records on a different window.
- Do the same but specify a layout based on a different table occurrence with the same data source table.
- Define the new "list of" summary field to list the primary keys. Save this list by using set field to copy the list to a global field. After making changes to your found set, you can use a self join with this global field as the match field to bring back the previous found set.
Thanks again, Phil. My brain's not wired for this and it took be a bit to get the relationship right, but the GTRR works like a charm.
Note that if the record you are going to isn't in the found set, this GTRR does the equivalent of a "find all" before putting the focus on the specified record.