FAQ #2580, published on 2002-10-15
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
Info(Cedex.City, Cedex.PostalCode) // displays Béziers, 34500