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?