>Yes, it's fast...but the problem is that the thumb on the grid's scroll bar doesn't work right. It should be used to scroll through all the data in the grid, but it doesn't as the displayed data is limited by the KEY or FILTER condition. It becomes frustrating to the user.
>
>>Check out the SET KEY command. Add an index on the child table that starts with the foreign key followed by the year. You can then "filter" the child table to the parent for a particular year like this..

Craig,

I'm not an advocate of SET KEY at all, and I don't think I've ever used it in a project, but the scrollbar does seem to work right opposed to when using a filter. The only odd things is that the size of the moverbar does not seem to be right.

Walter,