FAQ #2580, published on 2002-10-15
WINDEV
Is it possible to use a filter on one key, but browse the file on another?
Yes with the HyperFileSQL files! You only need to use the parameter
"hKeepFilter" at the beginning of the browse.

Here is an example of the Cedex file in the WD7 Stock project:

KeyFilter is string = HFilter(Cedex,"PostalCode='34500'")
Info("Filter Key", KeyFilter) // Key = PostalCode

// Browsing on the key City
HReadFirst(Cedex,City,hKeepFilter)
Info(Cedex.City, Cedex.PostalCode) // displays Béziers, 34500