Malcolm

Instead of an SQL select (funny how you guys say a SQL "Sequel" when we say an SQL "Ess-Kyu-Ell"), how about an updateable View, itself the same as the SQL?

Terry

>I have a grid that displays a filtered set of records from a relatively small table. Unfortunately, the grid scrollbar does not respect the filtered set of records and instead updates itself based on a record's current position in the unfiltered view of the table. This can look pretty whacky.
>
>I have a hunch that this is "by design". Any way to fix this other than using a SQL select into a seperate cursor? Normally this is the way I would do things, but in the situation at hand there are many controls on a page that can update fields displayed in the grid. Thus I was hoping to use a filtered view (USE AGAIN) of the same table being managed by the form vs. writing complicated logic to forward discrete updates to the grid.
>
>Thoughts?
>
>Malcolm