We have a calendar that displays entries as rows in Table view. One way users can arrive there is via a GTRR from a related table; in this case, we want to persist the pre-existing found set and sort order in the Table view.

This works up to a point. But the selected entry is usually displayed at the bottom of the window. How can we adjust the display so that the record is shown at the top of the window - with the same found set and sort order as before?

Or is there a better way to do this avoiding the GTRR step?

Many thanks in advance, W.

I'm trying to imagine bringing a record to the top, but not change the sort order?

I think that you'll find that as a developer, list views give you more control. You could display the contents of the current record in fields in the header part.

Is it hard to imagine? The user would do it by scrolling...

Thanks anyway. The point really is to retain the context, so putting data in the header doesn't really help. The user should be able to see the entries following the selected record.

Edited November 13, 200916 yr by Guest

OK. Have found a way to do this.

Scroll Window To Selection

Scroll Window Page Down

Go to Record Previous

Go to Record Next

Kludge that works. Moving records when the selected record is off screen prompts the listing to scroll to more or less where I want it.

If [ Get ( RecordNumber ) > 1 ]

Go to Record [ Previous ]

Scroll Window [ Page Down ]

Go to Record [ Next ]

End If

The step:

Scroll Window [ To Selection ]

doesn't do anything ( in this case )

My mind didn't even go to scrolling. I was stuck on having the record be the first record in the list--not the first VISIBLE record in the list.