Jump to content

Scroll to a Record

This topic is 6502 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 6502 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.