Searching on a non-key column ?

theredmiata

All,

I was wondering if it's possible to search for a particular value in a column that is not indexed (keyed) ? I've looked at the examples and they always seem to refer to searching on the key (which is a correct) but there are instances where I need to search outside of the key for example:

In the Picking List report, my users would like to see the WHSSHIP# which is located in the Warehouse Shipment Line table. I imagine that I could probably use the setcurrentfilter option perhaps ?

Any help would be greatly appreciated.

Thanks!

ian

kriki

You can put filters on all fields that exist in a table, even flowfields. But this (in general) will be slower than filtering on fields in the current index, provided that you put filters on all fields in the index previous the the current field.