Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limiting records that show in a grid
Message
From
11/02/2006 06:26:17
Walter Meester
HoogkarspelNetherlands
 
 
To
10/02/2006 09:57:49
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01095298
Message ID:
01095625
Views:
11
>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,
Previous
Reply
Map
View

Click here to load this message in the networking platform