I have had to do this for a client a couple of years ago.
We achieved this by creating a Gridview Workspace that contains a number of Views.

Briefly, we are performing a search of the Description field of all the detail OE records.
We first perform a search in the first View for a specific Customer for some text, such as “red”, that appears anywhere in the Description field of all the historical OE Invoices.
This generates a second View that filters all the records that contain the word “red” anywhere in the Details line (with other relevant data).
We next click in this second View to further limit the View for another text, such as “large”.
This generates a third View that displays only the records that display both the words “red” and "large".

This is a bit complicated, but if you are performing these kinds of searches on a regular basis, it may be well worth it to create this Workspace.

You can ask your dealer about this, or either you or your dealer can contact me for more information.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON