Scroll to a Record

[Oldfogey]

I'm creating a db to keep track of stock (shares not sheep). My main layout is a list of all stock held. The records displayed are 'masters'; all sell/buy transactions are omitted but related to the 'master', which contains the net position. Clicking on the name of a stock, displays a button menu for that record only. The menu items are Increase, Decrease, Edit, etc.

Take Increase - buying some more. Clicking the button takes me to a specific layout where details of the new purchase are entered. For reasons I won't go into, the original current record is now no longer the current record so when I return to my list, it may well have moved position on the screen.

Does anyone know a nice simple way of restoring the list screen to exactly the way it looked before? I'd be happy to scroll the selected record to the top of the screen before letting the user click a button but how?

FileMaker Version: Dev 6

Platform: Windows 2000

[Vaughan]

It cannot be restored *exactly* the same.

Make a global number field gPortalRow. Set Status(CurrentPortalRow) to remember what row was clicked on. Do this in the script that takes the person to the detail.

When returning to the layout, do a Go To Portal Row script step, by field and specify gPortalRow. This will make the portal scroll don so that the portal row clicked upon will be visible in the last row. This isn't quite how it may have been when clicked upon but it'll have to do.

[Oldfogey]

Thanks Vaughan but I can't see how that will work. My whole DB is already based on a self-join so I can't get the displayed records into a (higher level) portal. Or are you telling me that Status(CurrentPortalRow) et al works on ordinary displays?