Go to current month of current year?

[Matthew R White]

My table is sorted as follows (Month) then (Year) Then (Effective Date)

I've attached a picture as a reference.

 

When I enter the layout, I'd like filemaker to automatically scroll to the current Month of the Current Year as right now it shows the entire year and starts at the top.

 

Any thoughts on how to do this?

 

Thanks!

 

 

[comment]

Why not do a find?

[Matthew R White]

I'd like the whole year to be scrollable, i just wanted it to auto center on the current month as thats where we do most of our work, rather than having to scroll through hundreds of records each time...

[Fitch]

If you start with a Find, then do a Find All (or whatever found set you want), then Sort, you'll be on that found record within the sorted set.