Searching on a non-key column ?

theredmiatatheredmiata Member Posts: 18

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.




  • Options
    krikikriki Member, Moderator Posts: 9,090
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.