We have a View, based on: OE Hist Detail /w Head.
We are using the FIND function to lookup text anywhere in the Description field.
We display many columns, including the Inv #.
(This View is working nicely.)

Our question is:
Can we use the results of this first View, and run a second pass at the data, looking for text that is restricted to the Inv #’s on the first View?

For example, we look for the text “cylinder” and the result is 380 rows.
Now, we want to look again at all the O/E Detail History for the text “new rod”, but only look for this text in the Invoices that are listed in the first View.

Can this be done?
If yes, any suggestions?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON