>Harry,
>
>Use a parameterized view.
>
>>To avoid filtering or querying in large databases, in FP 2.6 I frequently used "BROWSE KEY (expr)" to achieve an instant browse provided the (expr) was appropriate for the current index. How do we achieve the same useful trick in vfp?

unless I'm misunderstanding something, views like that are not an option for me as I'm still using the FP 2.6 free tables (and must continue to do so for at least the rest of this year) while upgrading my application from 2.6 to vfp.

The BROWSE KEY still works in vfp but it looks ugly to have a browse all over the screen with all these pretty forms elsewhere! The question is, can I use the Browse Key or an equivalent within a grid.

Thanks
Harry